1、下载MySQL docker镜像,运行mysql
docker pull mysql/mysql-server:latest
执行docker run命令,运行mysql
docker run --name sc-mysql -v /data/mysql-8.0:/var/lib/mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 -d mysql/mysql-server:latest
2、查看MySQL镜像运行状态
docker ps -a | grep mysql
3、用容器id进入MySQL容器,执行mysql命令登录MySQL
docker exec -it d498d9f00612 /bin/bash
mysql -uroot -p123456
4、查看用户信息
select host, user, authentication_string, plugin from mysql.user;
5、修改 root 用户 ,把host修改为%
use mysql;
update user set host = '%' where user = 'root';
FLUSH PRIVILEGES;
alter user 'root'@'%' identified with mysql_native_password by '123456';
用Navicat 测试连接