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
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?
Environment: Debian lenny/ kernel 126.96.36.199/ mysql 5.0