php5+mysql5请教！

josephpei

debian testing
apache2.0.55+php5.0.5+mysql5.0.16
一切都是apt-get安装的，并且安装了php5-mysql，在/etc/php5/apache2/php.ini中去掉了mysql.so和gd.so的注释，现在问题是mysql_connect链接时出现错误
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'josephpei'@'localhost' (using password: YES) in /home/josephpei/website/testdb.php on line 2
fail

并且命令行下mysql -u root -p也是同样的access denied

ideawu

引自：http://forum.java.sun.com/thread ... p;messageID=3921118
localhost and 127.0.0.1 are not treated the same in MySQL. You need another GRANT statement for that user with "user@127.0.0.1" rather than "user@localhost" or "user@localhost.localdomain"

是否这个问题？

eTony

mysql -u root

josephpei

hit-pei:/home/josephpei/website# mysql -h 127.0.0.1 -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

xiejw

读一下mysql的manual，设置一下root帐号 设置一下mysql的user表

josephpei

解决了，mysqld_safe强制更改root密码，然后就可以了