How to install mysql in docker

I use Docker desktop

prerequisites

1. Docker desktop run already. ( test docker at Powershell input docker ps )

Contrainer is show ( docker run already )

Step to install mysql

1. In power shell

docker pull myql

2.check image in docker

docker images

3. run docker contrainer

username : root

password : 11111111

database : testDb

port : 3306

docker run — name=mysqldb -e MYSQL_ROOT_PASSWORD=11111111 -e MYSQL_DATABASE=testql -p 3306:3306 -d mysql

4. check contrainer input command ‘

docker ps 

5. shell in contrainer to edit password

docker exec -it mysqldb bash

6. login to mysql

mysql -p 

7. check database use command

show databases;

8. alter password from root user

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY ‘11111111';

9. check login i use mysql Workbench ( You can use another tools for test )

10. Login success

reference : https://hub.docker.com/_/mysql