2020/05/02

How to create and connect with mysql client to mysql server running on docker container ?

1/ Download Docker form WIndows
https://docs.docker.com/toolbox/toolbox_install_windows/

2/Download mysql image and run mysql container
docker container run -it --detach --name mysql-server -p 3306:3306 --env MYSQL_RANDOM_ROOT_PASSWORD=yes mysql:latest

3/Configure mysql
docker container logs mysql-server
find secret random password under"GENERATED ROOT PASSWORD"



Set up access users and passwords
Ensure that there is at least one user that has configured remote connection fg '%'

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MNBVCXZ987654321';
ALTER USER 'root'@'%' IDENTIFIED BY 'MNBVCXZ987654321';
FLUSH PRIVILEGES;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
UPDATE mysql.user SET Host='%' WHERE Host='127.0.0.1' AND User='root';

4/Connect to mysql using MySql client

host: 127.0.0.1
port: 3306
user: root
password: (known)



Do not forget to stop IIS or at least change ip for mysql service (docker bridge)