[CentOS] mysql : Access denied for user
Andy Green
andy at warmcat.com
Sat May 20 08:13:03 UTC 2006
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');
Mysql passwords are a mantrap pit full of sharpened stakes and lizards.
I don't claim to understand the system, but I have three pieces of
advice that get me out of the deathpit:
- you MUST do
flush privileges;
after messing with the privs or your messing is ignored until you
restart mysqld.
- There are two kinds of password hashes in use, and they are
incompatible!!! IIRC password() makes the new kind and OLD_PASSWORD()
makes the older kind. Depending on the age of the client you are using
to connect, it will hash your password one way or the other.
- The privilege tables are done as database tables.
use mysql;
show tables;
will get you started. God help me I found it easier to mess with the
privilege tables directly -- don't forget the flush -- than use the sql
syntax.
Oh one more ... tables themselves have privileges separate from the
general login, but I don't think that's the problem here from the error.
-Andy
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 4492 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.centos.org/pipermail/centos/attachments/20060520/734d53a5/attachment.bin>
More information about the CentOS
mailing list