Thursday, March 11, 2021

Docker

 Install MySQL 5.7 in Docker


bash> docker pull mysql/mysql-server:5.7
bash> docker images
bash> docker run --name=mysql57 -d mysql/mysql-server:5.7
bash> docker logs mysql57
bash> docker exec -it mysql57 mysql -uroot -p
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpassword';
mysql> update mysql.user set host = '%' where user='root';
Quit from mysql client
docker restart mysql57
Connect from MySQL WorkBench
// Below script tag for SyntaxHighLighter