解决egg-mysql插件连接不上mysql问题;
【解决egg-mysql插件连接不上mysql问题;】解决egg-mysql连接不上MySql服务器报错:Client does not support authentication protocol requested by server;
consider upgrading MySQL client
- 问题原因
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 - GPLCopyright (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)
- 解决问题
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 - GPLCopyright (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_...
推荐阅读
- 基于Java解决华为机试实现整数与IP地址间的转换
- 基于Java解决华为机试实现密码截取
- HP开发中常见的安全问题详解和解决方法(如Sql注入、CSRF、Xss、CC等)
- php|PHP开发中常见的安全问题详解和解决方法(如Sql注入、CSRF、Xss、CC等)
- 好用不卡,这些插件和配置让你的|好用不卡,这些插件和配置让你的 Webstorm 更牛逼!
- opencv|win10 vscode opencv时运行出现 fatal error: opencv2/opencv.hpp: No such file or directory的超快解决方法
- 企业使用混合云面临的障碍及解决办法
- 在SpringBoot中注入RedisTemplate实例异常的解决方案
- .NET|.NET Core使用EF生成数据库出错的解决方法
- html页面预览pdf文件使用插件pdfh5.js