当我尝试通过远程MySQL服务器连接本地机器的shell时,我可以成功连接:
> mysql -h remotehost -u myuser -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
但是当我尝试使用PHP脚本连接时
$serverName = "remotehost"; // here I put the actual IP address
$userName = "myuser";
$passCode = "actualpassword";
mysql_connect($serverName,$userName,$passCode);
我得到了以下错误:
远程MySQL服务器版本是5.1.52,本地机器的PHP版本是5.3.10-1ubuntu3.4。警告:mysql_connect():用户'myuser'@'localhost'被拒绝访问(使用密码:YES)
我发现了一个类似的问题,但答案并没有解决我的问题: problem connecting to remote mysql database using php 我真的很感激一些帮助!
编辑:
php -i | grep "mysql"
的输出为:/etc/php5/cli/conf.d/mysql.ini,
/etc/php5/cli/conf.d/mysqli.ini,
/etc/php5/cli/conf.d/pdo_mysql.ini
mysql
MYSQL_SOCKET => /var/run/mysqld/mysqld.sock
MYSQL_INCLUDE => -I/usr/include/mysql
MYSQL_LIBS => -L/usr/lib/i386-linux-gnu -lmysqlclient_r
mysql.allow_local_infile => On => On
mysql.allow_persistent => On => On
mysql.connect_timeout => 60 => 60
mysql.default_host => no value => no value
mysql.default_password => no value => no value
mysql.default_port => no value => no value
mysql.default_socket => /var/run/mysqld/mysqld.sock => /var/run/mysqld/mysqld.sock
mysql.default_user => no value => no value
mysql.max_links => Unlimited => Unlimited
mysql.max_persistent => Unlimited => Unlimited
mysql.trace_mode => Off => Off
mysqli
MYSQLI_SOCKET => /var/run/mysqld/mysqld.sock
mysqli.allow_local_infile => On => On
mysqli.allow_persistent => On => On
mysqli.default_host => no value => no value
mysqli.default_port => 3306 => 3306
mysqli.default_pw => no value => no value
mysqli.default_socket => /var/run/mysqld/mysqld.sock => /var/run/mysqld/mysqld.sock
mysqli.default_user => no value => no value
mysqli.max_links => Unlimited => Unlimited
mysqli.max_persistent => Unlimited => Unlimited
mysqli.reconnect => Off => Off
PDO drivers => mysql
pdo_mysql
pdo_mysql.default_socket => /var/run/mysqld/mysqld.sock => /var/run/mysqld/mysqld.sock
mysql_
代码库?不应该再使用这个库编写新代码。它会让你容易受到SQL注入攻击(由于缺乏参数化查询支持)和潜在的其他未修补的漏洞。尽快切换到使用mysqli
或PDO
,然后学习如何编写参数化查询以保护你的数据免受恶意输入。请参考http://bobby-tables.com了解风险的简单解释以及一些编写安全查询的示例PHP代码。 - ADyson