SQLyog连接mysql8,报错1251

原因：mysql8以前的加密规则与mysql8以后的存在差异
CMD命令窗口执行以下命令：

ALTER USER 'root'@'localhost' IDENTIFIED BY '密码' PASSWORD EXPIRE NEVER;

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '密码';

FLUSH PRIVILEGES;