Navicat连接新装Mysql报错: Client does not support authentication protocol requested by server...
解决办法:
-
进入安装目录/bin
cd %PATH%\bin # %PATH% Mysql安装目录
-
登录mysql
# 登录 mysql -u root -p # 输入密码 Enter password: ************
-
重置密码
# 重置, root:默认用户名,123456:新密码 ALTER USER root@localhost IDENTIFIED WITH mysql_native_password BY '123456'; # 刷新MySQL的系统权限相关表 FLUSH PRIVILEGES;