navicat 连接 mysql 出现Client does not support authentication pr
安装了navicat 和 mysql,结果最后在navicat中连接mysql时,出现了如下错误提示:
Client does not support authentication protocol requested by server; consider upgrading MySQL client
解决方法:在mysqll里依次输入
1 USE mysql; 2 ALTER USER ‘root‘@‘localhost‘ IDENTIFIED WITH mysql_native_password BY ‘831015‘; 3 FLUSH PRIVILEGES;
记得点赞收藏。
温馨提示: 本文由Jm博客推荐,转载请保留链接: https://www.jmwww.net/SQL/15859.html
- 上一篇:adb 命令合集
- 下一篇:Oracle中创建触发器示例及注意事项