关于eggjs:解决eggmysql插件连接不上mysql问题

解决egg-mysql连贯不上MySql服务器报错：Client does not support authentication protocol requested by server; consider upgrading MySQL client

1. 问题起因

通过相干问题查阅，发现是因为navicat版本的问题造成连贯失败。mysql8 之前的版本中加密规定是mysql_native_password,而在mysql8之后,加密规定是caching_sha2_password

MySql查看版本号-1

LITING:~ liting$ mysql -uroot -p    // 进入mysql
Enter password:  //输出mysql明码，如下提醒示意登录胜利
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 24
Server version: 8.0.14 MySQL Community Server - GPL

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

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查看版本号-2（能够进入mysql后通过mysql命令查看）

mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.14    |
+-----------+
1 row in set (0.00 sec)

2. 解决问题

1.进入mysql

LITING:~ liting$ mysql -uroot -p
Enter password:  // mysql明码
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 26
Server version: 8.0.14 MySQL Community Server - GPL

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

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.

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 mysql
Database changed
mysql> 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_…