Remote Connection to MySQL Running on Docker from Linux HOST?

docker-remote-connection-mysql-linux.md

On Linux

sudo mkdir -p /usr/local/docker/mysql
sudo chmod 777 -R  /usr/local/docker/mysql
docker run -p 3306:3306 -v /usr/local/docker/mysql:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=root -d mysql/mysql-server:latest
docker ps
docker exec -it $CONTAINER_ID bash

On Docker container (Just do it once)

mysql -uroot -p
mysql> grant all privileges on *.* to 'root'@'%' identified by 'root';           
mysql> flush privileges;

On Linux

sudo apt-get install mysql-client -y
mysql -uroot -p --host 172.17.0.2