记录一下使用navicat时出现的问题
连接时报错:1251-Client does not support authentication protocol requested by server; consider upgrading MySQL client
解决方法:打开cmd进入mysql
先输入:
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER;
再输入:
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’;
再再输入:
FLUSH PRIVILEGES;
over!!!