NavitCat 连接MySQL8 Client does no

作者: shu2man | 来源:发表于2019-03-08 12:03 被阅读0次

出现如下错误

image.png

我们都知道MySQL8使用了加强的加密机制，既然NavitCat不支持，那就只好把加密机制降级到原来的的，如下图

image.png

alter user 'root'@'localhost' identified with mysql_native_password by '你的密码'

关键在于这句，mysql_native_password 是MySQL原来的加密机制，改好刷新就能连上了。

NavitCat 连接MySQL8 Client does no
出现如下错误我们都知道MySQL8使用了加强的加密机制，既然NavitCat不支持，那就只好把加密机制降级到原来...
Mac Navicat连接mysql8 Client does
连接Mysql8报错：Client does not suppo
代码：运行报错：Client does not support authentication protocol ...
Mysql8 连接提示 Client does not supp
进入mysql安装的bin文件USE mysql;ALTER USER 'root'@'localhost' ID...
Navicat连接Mysql报错：Client does not
Navicat连接新装Mysql报错： Client does not support authenticatio...
Nodejs连接Mysql报错：Error: Cannot en
Nodejs连接Mysql报错：Client does not support authentication pr...
'Client does not support authent
连接mysql时报错：'Client does not support authentication protoc...
node连接到navicat 提示Client does not
node连接到navicat 提示Client does not support authentication p...
Client does not support authenti
笔者用navicate连接mysql8.0，然后连接的时候提示"Client does not support a...
nivicat连接新安装的Mysql8.0 Client doe
nivicat连接新安装的Mysql8.0 Client does not support authentica...