PHP遠端連線mysql

標籤：

http://blog.chinaunix.net/uid-23215128-id-2951624.html

# mysql -uroot
mysql> use mysql;Database changedmysql> SELECT `Host`,`User` FROM `user`;+-----------+--------+| Host      | User   |+-----------+--------+| 127.0.0.1 | houtai || 127.0.0.1 | root   || ::1       | root   || localhost | houtai || localhost | root   |+-----------+--------+5 rows in set (0.00 sec)mysql> UPDATE `user` SET `Host` = ‘%‘ WHERE `User` = ‘root‘ LIMIT 1;Query OK, 1 row affected (0.00 sec)Rows matched: 1  Changed: 1  Warnings: 0mysql> SELECT `Host`,`User` FROM `user`;+-----------+--------+| Host      | User   |+-----------+--------+| %         | root   || 127.0.0.1 | houtai || 127.0.0.1 | root   || ::1       | root   || localhost | houtai |+-----------+--------+5 rows in set (0.00 sec)mysql> flush privileges;

遠程寫個PHP指令碼測試：

<?php$con = mysqli_connect("IP","root","密碼");if (!$con)  {  die(‘Could not connect: ‘ . mysql_error());  } else echo"connect ok!"?>

伺服器要關閉防火牆： iptables -F  (service iptables stop)

顯示： connect ok!   

 

PHP遠端連線mysql