navicat for mysql 链接时报错:1251-Client does not support authentication protocol requested by server
解决方法
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ’ root ‘;
这行代码有两层含义,第一:修改root的密码为’root’,摒弃原来的旧密码。第二:使用mysql_native_password对新密码进行编码。