PHP和MySQL远程主机

如何运行需要连接到远程主机上的MySQL的PHP​​脚本?

当我运行这个:

$dbHost = "example.com"; $dbUsername = "root"; $dbPassword = "pass"; $dbDatabase = "some_db"; $dbi = mysql_connect($dbHost, $dbUsername, $dbPassword) or die ("Unable to connect to Database Server."); mysql_select_db ($dbDatabase, $dbi) or die ("Could not select database."); 

…我得到:

  Warning: mysql_connect(): Access denied for user 'root'@'10.1.1.1' (using password: YES) in /home/foo/bar.php on line 9 

我应该更改哪些设置?

默认情况下,MySQL用户只能从本地主机访问数据库。 您需要使用GRANT添加您的IP或所有IP的访问权限。

 GRANT USAGE ON *.* to [email protected] IDENTIFIED BY 'password for user'; GRANT ALL PRIVILEGES ON foodatabasename.* TO [email protected]; FLUSH PRIVILEGES;