安装了最新版8.0 mysql；
使用navicat 10链接时 提示：
client does not support authentication protocol requested by server;consider upgrading mysql client
解决：
**命令窗口cmd，登录**
mysql -u root -p
登录后执行：
*ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '你的root账号密码';这个可能用不上*
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的root账号密码';
SELECT plugin FROM mysql.user WHERE User = 'root';
然后再 使用链接测试 应该就可以了；
安装了最新版8.0 mysql； 使用navicat 10链接时 提示： client does not supp...
错误：ER_NOT_SUPPORTED_AUTH_MODE: Client does not support au...
Navicat连接新装Mysql报错： Client does not support authenticatio...
Nodejs连接Mysql报错：Client does not support authentication pr...
连接mysql时报错：'Client does not support authentication protoc...
MySQL 版本错误处理 (Client does not support authentication prot...
问题：链接mysql报出以下错误：Client does not support authentication p...
nivicat连接新安装的Mysql8.0 Client does not support authentica...
用navicat 连接mysql8.0服务是报：Client does not support authentic...
笔者用navicate连接mysql8.0，然后连接的时候提示"Client does not support a...
本文标题：mysql client does not support au
本文链接：https://www.haomeiwen.com/subject/xnkckqtx.html
网友评论