Linux mysql远程连接
- 1.3306端口没有打开
进入iptables
vim /etc/sysconfig/iptables
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
重启iptables
service iptables restart
- 2 root用户赋权
grant all privileges on . to ‘root’@’%’ identified by ‘123456’ with grant option;
- 3.mysql服务 没有启动
service mysql start
问题解决