MYSQL错误码2059解决办法

mysql -u root -p

 select user,plugin from user where user='root';
 
 结果显示
 +------+-----------------------+
| user | plugin                |
+------+-----------------------+
| root | caching_sha2_password |
+------+-----------------------+

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

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '131556';

FLUSH PRIVILEGES;