Centos8中的mysql远程连接的那些坑

一.[2003-Can’t connect to MysQL server on ‘IP地址’ (10060 “Unknown error”)]

1.查看MySQL服务器是否运行
下面展示一些 。

[root@iZuf611cqx7ixh9t36tyhrZ ~]# ps -ef|grep mysql
root      175991       1  0 16:45 ?        00:00:00 /bin/sh /www/server/mysql/bin/mysqld_safe --datadir=/www/server/data --pid-file=/www/server/data/iZuf611cqx7ixh9t36tyhrZ.pid
mysql     176616  175991  0 16:45 ?        00:00:02 /www/server/mysql/bin/mysqld --basedir=/www/server/mysql --datadir=/www/server/data --plugin-dir=/www/server/mysql/lib/plugin --user=mysql --log-error=iZuf611cqx7ixh9t36tyhrZ.err --open-files-limit=65535 --pid-file=/www/server/data/iZuf611cqx7ixh9t36tyhrZ.pid --socket=/tmp/mysql.sock --port=3306
root      177415  177083  0 16:57 pts/1    00:00:00 grep --color=auto mysql

4.停止mysql服务器

[root@************~]# /etc/init.d/mysqld stop

3…启动MySQL服务器

[root@************~]# /etc/init.d/mysqld start

4.查看Roo权限

mysql> use mysql
Database changed
mysql> select host, user from user;
+-----------+------------------+
| host      | user             |
+-----------+------------------+
| %         | root             |
| localhost | mysql.infoschema |
| localhost | mysql.session    |
| localhost | mysql.sys        |
+-----------+------------------+
4 rows in set (0.00 sec)

是不是全部权限 “%” 不是的话 要 改

mysql> use mysql
Database changed
mysql> update user set host='%' where user ='root';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

3.防火墙
查看防火墙是否启动 Active: active (running) 运行中

 systemctl status firewalld.service
 

打开防火墙端口

firewall-cmd --zone=public --add-port=3306/tcp --permanent

重启防火墙

firewall-cmd --reload

查看防火墙开放端口

[root@************~]# firewall-cmd --list-ports
20/tcp 21/tcp 22/tcp 80/tcp 8888/tcp 39000-40000/tcp 3306/tcp

4.云服务器需要添加安全组