连接不上虚拟机的mysql
1.登录虚拟机的mysql
mysql -u root -p[密码]
2.设置远程主机登录
mysql> use mysql;
mysql> update user set user.Host='%' where user.User='root';
mysql> flush privileges;
3.检查虚拟机Mysql的端口是否对外开放
编辑防火墙文件打开3306端口
vim /etc/sysconfig/iptables
![](https://img.laitimes.com/img/9ZDMuAjOiMmIsIjOiQnIsISPrdEZwZ1Rh5WNXp1bwNjW1ZUba9VZwlHdsATOfd3bkFGazxCMx8VesATMfhHLlN3XnxCMwEzX0xiRGZkRGZ0Xy9GbvNGLpZTY1EmMZVDUSFTU4VFRR9Fd4VGdsYTMfVmepNHLrJXYtJXZ0F2dvwVZnFWbp1zczV2YvJHctM3cv1Ce-cmbw5SM4UmZlZWZhhTZzgjZyIDM3czNkVWNjljYkljZyETOw8CX5EzLcdDMxIDMy8CXn9Gbi9CXzV2Zh1WavwVbvNmLvR3YxUjL0M3Lc9CX6MHc0RHaiojIsJye.png)
4.重启防火墙
service iptables restart