SQLyog（navica)连接docker容器中的mysql8.0.12 报错1251 - Client does not support authentication protocol 解决办法

快来打我* 2022-01-21 09:37 498阅读 0赞

使用SQLyog（navicat）远程连接docker容器中的mysql8.0.12 报以下错误↓↓↓  
![在这里插入图片描述][20190609155256481.png]  
解决办法：  
一、在docker中启动mysql,定义端口号3306

\[root@localhost ~\]\# docker run -p 3306:3306 --name mysql01 -e MYSQL\_ROOT\_PASSWORD=123456 -d mysql

二、执行命令，输入密码

\[root@localhost ~\]\# docker exec -it mysql01 bash

root@863b69d78d4f:/\# mysql -uroot -p

Enter password:  
Welcome to the MySQL monitor. Commands end with ; or \\g.  
Your MySQL connection id is 8  
Server version: 8.0.12 MySQL Community Server - GPL

Oracle is a registered trademark of Oracle Corporation and/or its  
affiliates. Other names may be trademarks of their respective  
owners.

Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the current input statement.

mysql>

三、授权

mysql> GRANT ALL ON *.* TO ‘root’@’%’;

四、刷新权限

mysql> flush privileges;

五、更改加密规则

mysql> ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER;

六、更新root用户密码（123456是我的密码，要替换成自己的）

mysql> ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql\_native\_password BY ‘123456’;

七、刷新权限

mysql> flush privileges;

OK，可以了，再次使用 SQLyog(Navicat) 连接数据库。

转载请标明出处:[SQLyog（navica)连接docker容器中的mysql8.0.12 报错1251 - Client does not support authentication protocol 解决办法][SQLyog_navica_docker_mysql8.0.12 _1251 - Client does not support authentication protocol]

文章来源: [SQLyog（navica)连接docker容器中的mysql8.0.12 报错1251 - Client does not support authentication protocol 解决办法][SQLyog_navica_docker_mysql8.0.12 _1251 - Client does not support authentication protocol 1]

[20190609155256481.png]: /images/20220121/f1312181d94241459e7c6d150746732b.png
[SQLyog_navica_docker_mysql8.0.12 _1251 - Client does not support authentication protocol]: https://www.e-learn.cn/content/mysql/1256390
[SQLyog_navica_docker_mysql8.0.12 _1251 - Client does not support authentication protocol 1]: https://blog.csdn.net/a617973058/article/details/83009045