远程mysql连接 [英] Remote mysql connection

问题描述

我在localhost上做了一个网站，当我试图在主机上移动它，它显示我很多错误。似乎它不能连接到我的本地数据库。以下是代码：

I'd been making a web on localhost and when I tried to move it on host it shows me lots of errors. Seems like it can't connect to my local database. Here's the code:

$host = "myip";
$user = "root";
$pass = "";
$db = "mydatabase";

mysql_connect($host, $user, $pass);
mysql_select_db($db);
$on = mysql_fetch_row(mysql_query("SELECT COUNT(online) FROM characters WHERE online=1"));
echo "<br>Online: $on[0]<br><br>";

这里是输出：

Warning: mysql_connect() [function.mysql-connect]: Host 'myip' is not allowed to connect to this MySQL server in * on line 46

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in * on line 48

Online: 

b $ b

感谢您的帮助

Thanks for help

推荐答案

这是一个mysql用户权限问题。使用phpmyadmin创建一个新用户，例如，如果你从localhost连接，将主机设置为localhost，如果你从外部连接，则设置为％。

It's a mysql user permission problem. Create a new user with phpmyadmin for example and set it's host to localhost if you connect from localhost, or % if you are connecting from outside.

这篇关于远程mysql连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！