作者Aligu1009 (=.=)
看板Database
标题[请益] php无法连至mysql?
时间Sat Nov 13 00:01:04 2010
※ [本文转录自 PHP 看板 #1CtMGwyS ]
作者: Aligu1009 (=.=) 看板: PHP
标题: [请益] php无法连至mysql?
时间: Fri Nov 12 23:58:48 2010
我在RH Linux 上用source 安装 Apache MySQL PHP 至我自己的家目录下
(因为我没有管理者权限)
目前apache + php可正常使用，直接在shell 下用mysql -uusername -p
也可以正常的连上资料库
问题：当我从php中用
$con = mysql_connect("localhost","username","password") or
die ("cannot find server: " . mysql_error());
却会得到
Warning: mysql_connect() [function.mysql-connect]: Access denied for user
'username'@'localhost' (using password: YES) in
/home/sean/share/apache2/htdocs/dev/init_db.php on line 2
cannot find server: Access denied for user 'username'@'localhost' (using
password: YES)
我已用mysql的root帐号嚐试过以下的五种解法，但结果都一样：
GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES ON dbname.* TO
[email protected] IDENTIFIED by 'password';
GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES ON dbname.* TO
username@localhost IDENTIFIED by 'password';
SET PASSWORD FOR
[email protected]=PASSWORD('password');
SET PASSWORD FOR username@localhost=PASSWORD('password');
FLUSH privileges;
----
另外，我为了搞清楚到底是PHP的问题还是MySQL的问题，
我用python写了一小段程式access mysql资料库，同样发生exception:
"Access denied for user 'username'@'localhost' (using password: YES)"
有人有经验能分享吗？任何建议 (在我的帐号权限范围内) 我都能试试看
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 75.102.80.84
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 75.102.80.84
1F：→ Xenor:要不要直接看database mysql 里头的 user table? 11/15 21:56