环境:
系统 centos 6.5
MySQL 5.6
1.赋于权限
登陆MySQL
mysql -uroot -p
然后执行:
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
flush privileges;
2.打开端口
/sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT
/etc/init.d/iptables save
service iptables restart
完美解决