使mysql可以被远程连接

1. 授权

GRANT select,insert,delete,update ON mydb.* to tan IDENTIFIED by '123456';

2. 打开端口

1）关闭防火墙

chkconfig iptables off

service iptables stop

或

2）修改/etc/sysconfig/iptables 文件，加上

-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT

3. php代码

代码：

test.php

<?php

$db_host="192.168.1.2";

$db_user="tan";

$db_password="123456";

$db_name="mydb";

$company_table="company";

$link=mysql_connect($db_host,$db_user,$db_password) or die("连接数据库失败");

$db=mysql_select_db($db_name,$link);

$query="insert into $company_table (company) values ('tansf')";

$result=mysql_query($query);

$query="select * from $company_table";

$result=mysql_query($query);

$total=mysql_num_rows($result);

echo $total;

?>

访问 http://192.168.1.4/test.php