Linux to turn on MySQL remote connection setup steps.
MySQL remote connection linuxserviceserverusermysql default root user only local access, cannot remotely connect to manage MySQL database, Linux how to turn on MySQL remote connection? The setup steps are as follows:
1. Grant command to create a remote connection MySQL authorized user test
Mysql-u root-p
Mysql>grant all privileges on * * to [E- Mail protected] identified by ' test ' with GRANT OPTION;
Mysql>grant all privileges on * * to [E- Mail protected]"%" identified by ' test ' with GRANT OPTION;
The first sentence adds the Itlogger user authorization via Local machine (localhost) access, password ' test '. The second sentence is to grant the test user access from any other host (the wildcard%).
2. Set firewall to allow 3306 ports
Vi/etc/sysconfig/iptables
Add to
-A rh-firewall-1-input-m state--state new-m tcp-p TCP--dport 3306-j ACCEPT
(Note that the rule will not take effect until you add the-a rh-firewall-1-input-j REJECT--reject-with icmp-host-prohibited)
Restart Firewall service iptables restart
Linux to turn on MySQL remote connection