Access Denied Using Password:YES
Hi all,
i am suffering a problem, and here is the description.
After Using the root to login( it is a successful login), i created an user, e.g. XXYY using command - Create user xxyy identified by 'xxyy'; grant all on *.* to xxyy; FLUSH Privileges;
everything seems fine and phpMyAdmin have also displayed this new user with password
however, when i tired to use this user to login mysql with password using the syntax
mysql --host=localhost --user=xxyy --password=xxyy
i got Access Denied for user 'xxyy'@'localhost' (using password: YES)
then i tried to login the user without password and succeed.
i have tried to drop the user and create the user inside phpMyAdmin but the problem still occur.
What i have done wrong?
P.S. in the real situation, the username and password is different.
Guest OS: CENTOS 5.6
MYSQL VERSION: 5.0.77 from yum install
Subject
Written By
Posted
Access Denied Using Password:YES
July 31, 2011 10:03PM
September 14, 2011 08:36AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.