MySQL Open remote connection

1. Log in to MySQL

[Email protected] ~]# mysql-u root-p

Enter Password:

2. Turn on remote connections

GRANT all privileges on * * to ' root ' @ '% ' identified by ' [e-mail protected] ' with GRANT OPTION;

Root for MySQL user, [email protected] for user password

3. Refresh Permissions

FLUSH privileges;

4. Installing iptables

Yum install-y iptables

5. Edit the Open port list, add 3306 ports, and restart the firewall.

-A input-m state--state new-m tcp-p TCP--dport 3306-j ACCEPT

6. Restart the firewall

！！！ So it can be remote!!!

This article is from the "high-tech blog" blog, please be sure to keep this source http://gaopengju.blog.51cto.com/12830710/1942304

MySQL Open remote connection