1251-Client does not support authentication protocol requested by server

电脑硬盘坏了,换了个固态,今天下载MySQL的时候,按照步骤一步步来,结果最后用navicat连接的时候出现的问题。。。

1251-Client does not support authentication protocol requested by server

于是百度了一下,最后解决,现在记录一下方法。

首先用CMD进入MySQL的bin目录,我的是C:\Program Files\MySQL\MySQL Server 8.0\bin,然后输入命令:

mysql -u root -p   接着输入密码登录以后,输入命令:ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';   这就是把密码改为root ,同时使用mysql_native_password对新密码进行编码。到此就解决问题了

1251-Client does not support authentication protocol requested by server

 

查看这位老哥给的方法 https://my.oschina.net/u/3295928/blog/1811804