Error10061
的最可能原因应该是MySQL中root用户不允许其他ip连接MySQLmysql> 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;
[zhangsan @node01 /]$ sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
将bind-address= 127.0.0.1
这一行删除或者注释掉
mysql> quit
[zhangsan @node01 /]$ sudo systemctl restart mysqld
❝结束! ❞
字数不够300,水一下字数。
Navicat远程连接Linux的MySQL服务Error10061的解决方案
Navicat远程连接Linux的MySQL服务Error10061的解决方案
Navicat远程连接Linux的MySQL服务Error10061的解决方案