Docker 安装 MySQL

1. pull image（默认 MySQL 8.0+）

   • docker pull mysql

2. run mysql

   • docker run -d -p 3306:3306 --name mysql -e MYSQL_ROOT_PASSWORD=@Qwert123 mysql

3. 查看 MySQL 启动日志

   • docker logs -f mysql

4. 查看 MySQL 版本

   • docker exec -it mysql mysql --version

   mysql Ver 8.0.20 for Linux on x86_64 (MySQL Community Server - GPL)

5. exec mysql

   • docker exec -it mysql mysql -uroot -p

6. 改变密码加密策略（可选：方便旧版 Navicat 连接）

   • use mysql;
   • ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '@Qwert123';
   • flush privileges;

7. 改变密码加密策略（方便 Navicat 连接）

   • use mysql;
   • ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '@Qwert123';
   • flush privileges;

8. Navicat connect

    ip: localhost
    port: 3306
    username: root
    password: @Qwert123

附录

查看主机端口状态

• windows: netstat -aon|findstr "3306"
• linux: netstat -anp|grep 3306

客户端——无权访问

Host '172.16.1.78' is not allowed to connect to this MySQL server

• select host,user from mysql.user;
• update mysql.user set host = "%" where user = "root";
• flush privileges;