navicat 连接 mysql8 的时候报错 1251
分类:SQL
具体信息为:Client does not support authentication protocol requested by server; consider upgrading MySQL client
请问该怎么操作?
1个回复
-
xsmile
1、windows 命令行登录 mysql8
1-1、进入到MySQL的bin目录下
cd C:\Program Files\MySQL\MySQL Server 8.0\bin>
1-2、启动mysql
.\mysql -u root -p
2、输入密码,登录成功后,运行2条命令即可解决
2-1、alter user 'root'@'localhost' identified with mysql_native_password by '****';
2-2、flush privileges;
3、OK
---------------------
作者:Mrs_谭先生
原文: https://blog.csdn.net/qq_383698639/article/details/812984693年前 我来评论