Hi all,
I am having a problem with mysql. I set up root password
set password for root@localhost=password('xxxxxxxxx');
set password for root@'xxx.yyyy.com'=password('yyyyyyyy');
after that I tried to log in, but mysql says
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
I guess that I had the right password.
My friend told me that I might have used a wrong password, so I set up
new password for root.
However, mysql says the exactly same thing!!
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
I was not sure about the error, so I decided to remove mysql and
deleted /var/lib/mysql.
After that I reinstalled mysql and set up mysql again.
However, mysql again says
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
I am 100000% sure that I am using the right passward for root
I am quite puzzled by the error and need your help.
Does anyone know how I can fix this problem?
I am using CentOS4.3. Thank you for your help.
Cheers,
Joe
___________________________________________________
Try the New Netscape Mail Today!
Virtually Spam-Free | More Storage | Import Your Contact List
http://mail.netscape.com
