解决egg-mysql连贯不上MySql服务器报错：Client does not support authentication protocol requested by server; consider upgrading MySQL client
- 问题起因
通过相干问题查阅，发现是因为navicat版本的问题造成连贯失败。mysql8 之前的版本中加密规定是mysql_native_password,而在mysql8之后,加密规定是caching_sha2_password
MySql查看版本号-1
LITING:~ liting$ mysql -uroot -p // 进入mysqlEnter password: //输出mysql明码，如下提醒示意登录胜利Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 24Server version: 8.0.14 MySQL Community Server - GPLCopyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> MySql查看版本号-2（能够进入mysql后通过mysql命令查看）
mysql> select version();+-----------+| version() |+-----------+| 8.0.14 |+-----------+1 row in set (0.00 sec)- 解决问题
1.进入mysql
LITING:~ liting$ mysql -uroot -pEnter password: // mysql明码Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 26Server version: 8.0.14 MySQL Community Server - GPLCopyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.2.输出命令批改加密规定
1.ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER;
password替换为mysql连贯明码
ALTER USER 'root'@'localhost' IDENTIFIED BY '12345678' PASSWORD EXPIRE NEVER;2.ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’;
password为批改的新密码。
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';3.刷新权限，使批改失效。
FLUSH PRIVILEGES; 4.查看表中相干信息，确认批改是否真正失效
mysql> use mysql; //先应用命令 use mysqlDatabase changedmysql> select user,host,plugin from user where user='root'; // 在输出该命令+------+-----------+-----------------------+ | user | host | plugin |+------+-----------+-----------------------+| root | localhost | mysql_native_password |+------+-----------+-----------------------+1 row in set (0.00 sec)5.通过navicat连贯测试
参考起源：https://blog.csdn.net/weixin_...