MySQL Allow remote connection authorization method

MySQL database and Apache are not on the same server, you need to connect to MySQL remotely, this requires MySQL remote connection authorization, in order to secure only some IP can connect:

If you want the root user to connect to MySQL from IP 192.168.2.12 and set the password "123456", the authorization method is as follows:

1, enter mysql:mysql>grant all privileges on * * to ' root ' @ ' 192.168.2.12 ' identified by ' 123456 ' with GRANT OPTION;

Mysql>flush Privileges

2, in the 192.168.2.12 server can use the command can be remote connection MySQL, but found that the connection is not connected with the code, check the reason, found that the database server restarted, Httpd_can_newwork_connect will become 0, Causes the network to not connect to

HTTPD service, you need to turn it on:

Setsebool-p httpd_can_network_connect=1

3,php can connect to the remote database normally