SQLyog连接MySQL8出现错误2058的解决方法。留个记录。
use mysql;
select user,host from user where user=‘root’;
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
flush privileges;
亲测可用!!!
如果已经通过 update user set host=‘%’ where user=‘root’; 修改了用户的host,则需要使用以下命令。
ALTER USER ‘root’@‘%’ IDENTIFIED WITH mysql_native_password BY ‘123456’;