Configure Mysql to allow remote connection _ MySQL

Configure Mysql to allow remote connection to bitsCN.com

MySql-Server only allows access from the local machine (localhost, 127.0.0.1) for security reasons. this is no problem for the website architecture of both Web-Server and MySql-Server on the same Server. however, as the website traffic increases, the Server architecture may put the Web-Server and MySql-Server on independent servers in the later stage to improve the performance, in this case, MySql-Server must be modified to allow Web-Server for remote connection.

Suppose we have: Web-Server: 192.168.1.100 // ubuntu Mysql-Server: 192.168.1.101 // xp

We can follow the steps below to modify: 1. log on to Mysql-Server to connect to local mysql (only local connections are allowed by default)

View source bitsCN.com