windows连接虚拟机的Mysql

telnet ip port：来判断是否网络通，当然，前提是能ping通ip了。

首先，给3306开通防火墙

1. 首先查看firewall是否已开启： systemctl status firewalld.service
2. 开放端口（开放后需要更新规则才能生效）： firewall-cmd --zone=public --add-port=3000/tcp --permanent
3. 更新防火墙规则： firewall-cmd --reload

mysql> select user, host from mysql.user;
+------+-----------------------+
| user | host                  |
+------+-----------------------+
| root | 127.0.0.1             |
| root | ::1                   |
|      | localhost             |
| root | localhost             |
|      | localhost.localdomain |
| root | localhost.localdomain |
+------+-----------------------+
6 rows in set (0.01 sec)

其次，给root用户提供给外部客户端访问的权限，使用下面的命令

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123' WITH GRANT OPTION;

mysql> select user, host from mysql.user;
+------+-----------------------+
| user | host                  |
+------+-----------------------+
| root | %                     |
| root | 127.0.0.1             |
| root | ::1                   |
|      | localhost             |
| root | localhost             |
|      | localhost.localdomain |
| root | localhost.localdomain |
+------+-----------------------+
7 rows in set (0.00 sec)