如何运行需要连接到远程主机上的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;