mysql8 Client does not support authentication protocol requested by server 错误解决方法

我会带着你远行 2023-08-17 16:46 60阅读 0赞

转载自：https://blog.csdn.net/XDMFC/article/details/80263215

好不容易安装好mysql，但又出现了mysql客户端版本太低的问题。根据参考的这篇博客，完美的解决了该问题。

1、通过命令行进入解压的mysql根目录下。

2、登陆数据库

mysql -uroot -p

3、再输入root的密码：

1.  `Enter password: ******`
2.  `Welcome to the MySQL monitor. Commands end with ; or \g.`
3.  `Your MySQL connection id is 18`
4.  `Server version: 8.0.11 MySQL Community Server - GPL`
5.  `Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.`
6.  `Oracle is a registered trademark of Oracle Corporation and/or its`
7.  `affiliates. Other names may be trademarks of their respective`
8.  `owners.`
9.  `Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.`
10. `mysql>`

4、更改加密方式：

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

5、更改密码：该例子中 123为新密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123';

6、刷新：

mysql> FLUSH PRIVILEGES;

这步完成后我已经成功解决了问题。如果报错，可以看下面第7步，博主依然给出了解决方案

7、

// 如果报错ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'%'：

则是远程访问权限不正确，先选择[数据库][Link 1]，查看一下再更改：

[?][Link 2]

<table> 
 <tbody> 
 <tr> 
 <td> 1 2 3 4 5 6 7 8 9 10 11 12 13 </td> 
 <td> <code>mysql&gt; use mysql;</code> <code>Database</code> <code>changed</code> &nbsp; <code>mysql&gt;&nbsp;</code><code>select</code> <code>user</code><code>,host&nbsp;</code><code>from</code> <code>user</code><code>;</code> <code>+</code><code>------------------+-----------+</code> <code>|&nbsp;</code><code>user</code>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <code>| host&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> <code>+</code><code>------------------+-----------+</code> <code>| mysql.infoschema | localhost |</code> <code>| mysql.session&nbsp;&nbsp;&nbsp; | localhost |</code> <code>| mysql.sys&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | localhost |</code> <code>| root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | localhost |</code> <code>+</code><code>------------------+-----------+</code> <code>5&nbsp;</code><code>rows</code> <code>in</code> <code>set</code> <code>(0.00 sec)</code> &nbsp; </td> 
 </tr> 
 </tbody> 
</table>

最后，感谢参考的该博主。此次转载只希望帮助更多的人，毕竟在犄角旮旯里找到这个方案不容易。若有人想要转载，请注明原博主，谢谢。

[Link 1]: https://www.2cto.com/database/
[Link 2]: https://www.2cto.com/database/201805/743719.html#

mysql8 Client does not support authentication protocol requested by server 错误解决方法

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 Client does not support authentication protocol requested by server； consider upgrading MySQL client

相关 mysql8 Client does not support authentication protocol requested by server 错误解决方法

相关 MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading

相关 Navicat连接MySQL：1251-Client does not support authentication protocol requested by server

相关 navicat 连接 mysql 出现Client does not support authentication protocol requested by server

相关 MySQL 8.0版本出现Client does not support authentication protocol requested by server

相关关于MySQL密码验证，Client does not support authentication protocol requested by server

相关 client does not support authentication protocol requested by server;consider upgrading mysql client

相关 1251 - Client does not support authentication protocol requested by server;consider upgrading MySQL

相关 1251-client does not support authentication protocol requested by server