php远程连接服务器mysql数据库

本人以linux为例
将localhost改为具体ip地址

$link = mysql_connect("localhost","root","");

$link = mysql_connect("192.168.0.31","root","");

1. 打开mysql

   键入命令：./etc/init.d/mysql start

2. 进去MySQL

   进去MySQL mysql -hlocalhost

3. 键入(重点)GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
   其中user为mysql用户名，默认为root，password为密码，%代表任意主机。

4. flush privileges;更新缓存，完成。

附简单连接代码

<?php
 $link = mysql_connect("192.168.0.31","root","");//连接数据库
 mysql_select_db("test",$link); 
 //查询代码
 $sql = "select * from students";
 $send = mysql_query($sql);
        while($row = mysql_fetch_row($send)){

                foreach($row as $v){
                        echo "$v";

                }
                echo "<br>";
        }

?>