Navicat远程连接Linux的MySQL服务Error10061的解决方案

写在前面

• Linux：Ubuntu Kylin16.04
• MySQL: 5.7.33

解决方法

• 原因：关于Error10061 的最可能原因应该是MySQL中root用户不允许其他ip连接MySQL

• 修改mysql库下的user表中的root用户允许任意ip连接

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql> select user, host from user where user = 'root';
+------+-----------+
| user | host      |
+------+-----------+
| root | localhost |
+------+-----------+

mysql> update mysql.user set host='%' where user='root';

mysql> select user, host from user where user = 'root';
+------+------+
| user | host |
+------+------+
| root | %    |
+------+------+
1 row in set (0.00 sec)

• 刷新权限

mysql> flush privileges;

• 修改MySQL配置文件

[zhangsan @node01 /]$ sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

将bind-address= 127.0.0.1这一行删除或者注释掉

• 再次连接不成功，重启MySQL服务

mysql> quit
[zhangsan @node01 /]$ sudo systemctl restart mysqld

结束！