Sharad Raj

AI, full-stack, and Flutter developer with a master’s in Data Science, focused on building integrated solutions.

Docker :ship: MySQL setup

12 Oct 2020

Step 1

docker pull mysql/mysql-server:latest

and check

docker images

then

docker run --name=[name-of-container] -d mysql/mysql-server:latest

then

docker ps

Step 2: Find password

docker logs [name-of-container] 2>&1 | grep GENERATED

Step 3

docker exec -it [name-of-container] mysql -uroot -p

Step 4: Change password

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'your-password-here';

Other commands

Start

docker start [name-of-container]

Stop

docker stop [name-of-container]

delete

docker stop [name-of-container]
docker rm [name-of-container]

Errors

In case of

dial unix /var/run/docker.sock: connect: permission denied

run

sudo setfacl --modify user:<user name or ID>:rw /var/run/docker.sock