007-解决Navicat报错1251-Client does not support authentication p
报错:
解决方法:
输入select host,user,plugin,authentication_string from mysql.user; 看用户信息
更改加密方式,重置密码:(原加密方式为:alter user ‘root‘@‘localhost‘ identified by ‘123‘;)
alter user ‘root‘@‘localhost‘ identified by ‘123‘;
刷新权限:flush privileges;
再看看加密方式:
没有乱码现象
再次尝试:
温馨提示: 本文由Jm博客推荐,转载请保留链接: https://www.jmwww.net/SQL/12215.html