![]() |
|
首页 │ Apache │ Linux│ Java│ MySQL│ 注册│帮助 | |||
如何书写php远程访问mysql?
比如:
假如我在主机192.168.0.130 和192.168.0.131 分别都建立一个用户
mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost
IDENTIFIED BY 'something' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%"
IDENTIFIED BY 'something' WITH GRANT OPTION;
然后我该怎么用php从另一台远端的电脑访问此mysql?是这样吗?还是有什么更好的办法?
[PHP]
<?PHP
//访问192.168.0.130
$gcHostID="192.168.0.130";
$gcUserID="root";
$gcPassword="root";
$tSystemDatabase='database';
$connect=mysql_connect($gcHostID,$gcUserID,$gcPassword)
or die("<script language='javascript'>alert('无法和服务器建立连接﹐请稍后在试!');location.href='Index.php';</script>");
$result=mysql_select_db($tSystemDatabase)
or die("<script language='javascript'>alert('无法和数据库建立连接﹐数据库正在使用中!');location.href='Index.php';</script>");
?>
<?PHP
//访问192.168.0.131
$gcHostID="192.168.0.131";
$gcUserID="root";
$gcPassword="root";
$tSystemDatabase='database';
$connect=mysql_connect($gcHostID,$gcUserID,$gcPassword)
or die("<script language='javascript'>alert('无法和服务器建立连接﹐请稍后在试!');location.href='Index.php';</script>");
$result=mysql_select_db($tSystemDatabase)
or die("<script language='javascript'>alert('无法和数据库建立连接﹐数据库正在使用中!');location.href='Index.php';</script>");
?>
[/PHP]

