当前位置：Gxlcms >
数据库问题 >
navicat连接mysql出现Client does not support authentication protocol requested by server解决方案
navicat连接mysql出现Client does not support authentication protocol requested by server解决方案
时间：2021-07-01 10:21:17
帮助过：15人阅读
mysql;
ALTER USER ‘root‘@
‘localhost‘ IDENTIFIED
WITH mysql_native_password
BY ‘831015‘;
FLUSH PRIVILEGES;
root是用户名
localhost是ip地址127.0.0.1都是特指本机，%表示任何IP都可访问
mysql_native_password是旧的密码验证机制，831015是密码，最后别忘了分号；
navicat连接mysql出现Client does not support authentication protocol requested by server解决方案
标签：toc word prot roo 密码验证 用户 port 表示 alt
