- 启动 MySQL 容器
docker run --name mysql8 -e MYSQL_ROOT_PASSWORD=root -d mysql:8
- 进入容器终端登录 root 用户
mysql -uroot -p
root
- 配置 mysql 用户远程连接权限
use mysql;
grant all privileges on *.* to 'root'@'%' with grant option;
flush privileges;
- navicat 连接 MySQL 8 报错 1251
use mysql;
ALTER USER 'root'@'%' IDENTIFIED BY 'root' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
flush privileges;