[Solved] Database is uninitialized and password option is not specified

 

Issue:- 

When  launching a mysql container from an image from mysql:5.7 image the container stops with error message saying to put the environment variable for the mysql root password.

Error:- 

2023-01-09 07:41:52+00:00 [ERROR] [Entrypoint]: Database is uninitialized and password option is not specified
    You need to specify one of the following as an environment variable:
    - MYSQL_ROOT_PASSWORD
    - MYSQL_ALLOW_EMPTY_PASSWORD
    - MYSQL_RANDOM_ROOT_PASSWORD(2003, "Can't connect to MySQL server on '127.0.0.1' ([Errno 111] Connection refused)")      

Effect:-

mysql container automatically goes down after few mins

Resolution:-

For making the container work you can pass the environment variables at the runtime with docker run which

would solve the issue here.

docker run -itd -p 3306:3306 -e MYSQL_ROOT_PASSWORD=abc --name couter-db mysql