本人以linux为例
将localhost改为具体ip地址
$link = mysql_connect("localhost","root","");
$link = mysql_connect("192.168.0.31","root","");
-
打开mysql
键入命令:./etc/init.d/mysql start
-
进去MySQL
进去MySQL mysql -hlocalhost
-
键入(重点)
GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
其中user为mysql用户名,默认为root,password为密码,%代表任意主机。 -
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>";
}
?>