docker + mysql

1. 下载mysql镜像

docker pull mysql:5.6

2. 运行镜像

• windows

docker run -d --privileged=true --name mysql-test -v //e/ProgramData/docker:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -p 33306:3306 mysql:5.6

*mac

docker run -d --privileged=true --name mysql-test -v /Users/tangx/Documents/mysql/statistic:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -p 33306:3306 mysql:5.6

3. 解决外网不能访问数据库的问题

docker exec -it mysql-test bash

mysql>show databases;
mysql>use mysql;
mysql>select host from user where user='root' AND host='localhost';
mysql>update user set host='%' where user='root' AND host='localhost';
mysql>flush privileges;