ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

shogun1234 · 06-15-2009, 10:46 AM

I use debian's apt-get/ aptitude to install mysql 5.0 on the laptop. However, after installation completes, I can not login using `mysql -u root -p`. The command prompt always complains ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES).

I search on the internet, discovering several solution. Unfortunately, neither reset password (http://forums.mysql.com/read.php?11,...6593#msg-46593) using debian-sys-maint to reset password or use mysqld_safe would work. I am completely confused. What should I do to find the possible root cause?

Also, I've check the processes

Code:

mysqld_safe

mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock

logger -p daemon.err -t mysqld_safe -i -t mysqld

with regards to the binding parameter (http://dev.mysql.com/doc/refman/5.1/...ss-denied.html), there is no restriction showing that it only allow localhost connect (Even so, indeed I connect on the machine, not on the remote server).

How can I solve such problem? Or where to find resource that explain this better?

Many thanks,

Environment: Debian lenny/ kernel 2.6.27.8/ mysql 5.0

forrestt · 06-15-2009, 11:12 AM

Do you actually have 'localhost' listed in the Host field of the mysql users table for a root user? You may have '127.0.0.1' listed instead. To MySQL these aren't the same. It is a bit confusing I know, but if you don't have localhost, you can either change 127.0.0.1 to localhost (not recommended by me) or just add a duplicate root entry with 'localhost' replacing the '127.0.0.1' and then restart mysqld or flush your grant tables.

HTH

Forrest