Linux-docker下载使用mysql:5.6.51

1 下载mysql 5.6.51

docker pull mysql:5.6.51

2 建立容器

docker run -itd -P -name mysql5651 -e MYSQL_ROOT_PASSWORD=root -e TZ=Asia/Shanghai mysql:5.6.51

-P ：随机端口号

-e MYSQL_ROOT_PASSWORD=root ：密码设为root

-e TZ=Asia/Shanghai：设置时区

3 测试连接

docker run -it --rm mysql:5.6.51 mysql -h192.168.1.115 -uroot -proot -P49165

mysql> select user,host,plugin from mysql.user; 
+------------------+-----------+-----------------------+ 
| user		       | host      | plugin                | 
+------------------+-----------+-----------------------+ 
| root             | %         | caching_sha2_password | 
| mysql.infoschema | localhost | caching_sha2_password | 
| mysql.session    | localhost | caching_sha2_password | 
| mysql.sys        | localhost | caching_sha2_password | 
| root             | localhost | caching_sha2_password | 
+------------------+-----------+-----------------------+ 
5 rows in set (0.00 sec)