Navicat连接不上mysql数据库(mysql数据库客户端需要升级)
解决方法:
打开命令行
cd C:\Program Files\MySQL\MySQL Server 8.0\bin
mysql –u 用户名 –p 密码
USE mysql; ALTER USER 'root'@'localhost'IDENTIFIED WITH mysql_native_password BY '密码';
FLUSH PRIVILEGES;
打开命令行
cd C:\Program Files\MySQL\MySQL Server 8.0\bin
mysql –u 用户名 –p 密码
USE mysql; ALTER USER 'root'@'localhost'IDENTIFIED WITH mysql_native_password BY '密码';
FLUSH PRIVILEGES;