[CentOS] mysql : Access denied for user

[Johnny Hughes]

On Fri, 2006-05-19 at 23:23 -0400, kenkensmile at netscape.net wrote:
> Hi all,
> 
> I am having a problem with mysql. I set up root password
> 
> set password for root at 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.
> 

OK ... another thing that I see frequently when dealing with this issue
is the location of localhost in your /etc/hosts file ... don't ask me
why, but it sometimes matters.  Put the localhost name first in the
line, like this:


127.0.0.1 localhost xxxxx yyyy.yyy


(where xxxxx and yyyy.yyy are the other names currently on the loopback
line)

_OR_

use the first name in the /etc/hosts in the 127.0.0.1 line as the @
machine name.

The first field after the IP address is name .. the others are aliases.
MySQL seems to have issues with aliases sometimes.

At least, that is my observation ...


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
URL: <http://lists.centos.org/pipermail/centos/attachments/20060520/ca3ebcda/attachment.sig>