1130 Host is not allowed to connect this MySQL server 解决办法or2059 -Authentication plugin 'caching_sha

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '密码' PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.01 sec)

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '密码'
    -> ;
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)

OK解决

然后报了 2059 -Authentication plugin 'caching_sha2_password'

一看plugin不对  解决方法：

mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '密码' ;
Query OK, 0 rows affected (0.01 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

OK登陆成功

 

如果你觉得这篇内容对你挺有启发请点赞+关注