使用Navicat Premium连接数据报错

1130 - Host ‘125.85.166.60’ is not allowed to connect to this MySQL server

[root@VM_0_9_centos: mysql]#mysql -uroot -p
Enter password: 
mysql> use mysql;
# host 是localhost表示只能本地连接
mysql> select host,user from user;
+-----------+------------------+
| host      | user             |
+-----------+------------------+
| localhost | mysql.infoschema |
| localhost | mysql.session    |
| localhost | mysql.sys        |
| localhost | root             |
+-----------+------------------+
4 rows in set (0.00 sec)
## 将root 账号的host改成%,再刷新缓存
mysql> update user set host='%' where user='root';
mysql> flush privileges;

2003 - Can’t connect to MySQL server on ‘122.51.128.161’ (10060 “Unknown error”)

1. 设置权限

use mysql;
# 使用的mysql是8.0.20
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
# 刷新缓存
FLUSH PRIVILEGES;

2. 设置服务器安全组（如果是云服务器的话）
   
3. 将防火墙关闭或开启端口允许外部网络访问

2059 -Atentiation plugin ‘caching sha2 psword’ canot be loaded: *******

修改账户密码加密规则并更新用户密码

#修改加密规则 
ALTER USER 'root'@'%' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;

#更新一下用户的密码 
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '您的mysql密码';
# 刷新缓存
flush privileges;

Connection is being used

1、在已经保存的连接上上编辑，测试连接成功，但是点击连接就会一直提示 connection is being used

2、需要新建一个连接，才能使用，不能再已保存的上面修改