centos6.5 MySQL settings support remote IP access

　　

Just show the user name and host to

Mysql> Grant all privileges on * * to [e-mail protected] ' 192.168.2.96 ' identified by ' Crmbbs ';

This sentence means: Set an account for Wudaogang password for Crmbbs IP for 192.168.2.96 this IP to access MySQL

If the change is: Grant all privileges on test.* to [email protected] ' 192.168.2.96 ' identified by ' Crmbbs ';

Indicates that you can manipulate only the test database other databases you cannot manipulate *. * indicates that you can manipulate all databases

See Query ok! Indicates that the execution was successful.

Last update on MySQL permissions

Flush privileges;

If you don't have a link at this point, your firewall doesn't have port 3306 open.

#/sbin/iptables-i input-p TCP--dport 80-j accept#/sbin/iptables-i input-p tcp--dport 3306-j ACCEPT

　　

#/etc/rc.d/init.d/iptables Save

View open ports When Setup is complete:

#/etc/init.d/iptables Status

Reboot the firewall and

/etc/init.d/iptables restart

This is the end of the MySQL remote account link ~

centos6.5 MySQL settings support remote IP access