如何使用PHP从另一个IP地址访问另一个MySQL数据库?

mysql_connect()

$resource = mysql_connect('other-server-address.com', 'username', 'password');

端口号。例如“主机名:端口”或 本地主机的“:/path/to/socket”。

如果PHP指令 此参数将被忽略并取值

• Grant access to the mysql user to connect from the other host
• my.ini settings not allowing outside connections

• Connecting to MySQL from other machines
• How do I enable external access to MySQL Server?
• php access to remote database
• How to make mysql accept connections externally
• Remote mysql connection

mysql>  grant all on mydb.* to 'someuser'@'192.168.1.30' identified by 'secretpass;

您的PHP代码通过以下方式连接到该数据库:

$conn = mysql_connect('192.168.1.20', 'someuser', 'secretpass');

$link1 = mysql_connect($host1, $username1, $password1);
$link2 = mysql_connect($host2, $username2, $password2);
$r = mysql_query(QUERY, $link1);