解决Navicat链接mysql报错：ERROR 2002 (HY000): Can‘t connect to MySQL server on ‘192.168.564.118‘

报错如下所示：

ERROR 2002 (HY000): Can't connect to MySQL server on '192.168.564.118'

1、新增mysql账号和密码

mysql> SELECT user, host FROM mysql.user WHERE user = 'root' AND host = '%';
+------+------+
| user | host |
+------+------+
| root | %    |
+------+------+
1 row in set (0.00 sec)

mysql> CREATE USER 'Mh'@'%' IDENTIFIED BY 'Mh@123456';
Query OK, 0 rows affected (0.02 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'Mh'@'%';
Query OK, 0 rows affected (0.00 sec)

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

2、检查 MySQL 服务状态

在 CentOS 服务器上确认 MySQL 服务正在运行，使用命令systemctl status mysqld检查服务状态。如果未运行，