1.使用Docker安装Mysql并修复字符集+设置密码,请参考
。https://blog.csdn.net/Asia1752/article/details/103383361
2.用远程连接工具连接
刚安装运行mysql容器时,利用远程连接工具(SQLYog、Navicat等)连接mysql,会报错:
"1251 Client does not support authentication protocol requested by server"
这个时候,进入linux,运行
docker exec -it mysql /bin/bash
此时已经进入mysql容器内部。登录mysql:
mysql -uroot -p
--- 输入你的密码
ok,已经成功登录mysql.
输入如下命令:
use mysql;
select user,host from user;
+------------------+-----------+
| user | host |
+------------------+-----------+
| root | % |
| mysql.infoschema | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
+------------------ +-----------+
查看你的root名的host是不是localhost,不是的话改成相应的名字再试一试。我的是%,就输入:
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '自己设置密码';
如果是localhost,则输入:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '自己设置密码';
然后刷新一下:
flush privileges;
经过以上步骤,就配置好啦。设置好之后,再次用连接工具连接,连接成功,亲测有效!