USE mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '831015';
FLUSH PRIVILEGES;
root是用户名，localhost是ip地址127.0.0.1都是特指本机，mysql_native_password是旧的密码验证机制，831015是密码，最后别忘了分号；
最后问题解决
USE mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '831015';
FLUSH PRIVILEGES;
root是用户名，localhost是ip地址127.0.0.1都是特指本机，mysql_native_password是旧的密码验证机制，831015是密码，最后别忘了分号；
最后问题解决
参考解决办法：https://blog.csdn.net/u013700358/article/details/8...
USE mysql; ALTER USER 'root'@'localhost' IDENTIFIED WITH ...
修改一次密码 oot是用户名，localhost是ip地址127.0.0.1都是特指本机，mysql_native...
USE mysql;ALTER USER 'root'@'%' IDENTIFIED WITH mysql_nat...
Navicat连接新装Mysql报错： Client does not support authenticatio...
用navicat 连接mysql8.0服务是报：Client does not support authentic...
使用Navicat连接MySQL有时会出现报错1251的情况 错误提示1251-Client does not s...
成功安装mysql8.0服务器端，连接Navicat会提示报错： 1251 Client does not sup...
node连接到navicat 提示Client does not support authentication p...
命令如下： 1、use mysql; 2、alter user 'root'@'localhost' identi...
本文标题：navicat 连接 mysql 出现Client does n
本文链接：https://www.haomeiwen.com/subject/oezlpqtx.html
网友评论