mysql user password funkyness

Everyone,

So I have never seen this before. I set up a database yesterday. I added a user today in the normal manner..

ie

grant usage on *.* to 'username'@'%' identified by 'password';

Here is the thing. You exit the console and try to log in with mysql -u username -ppassword and it won't let you in...

BUT it log in with both "mysql -u username" and also "mysql -u username -p (hit enter key)". So the user account works without a password.

executing the show grants command shows a password so this shouldn't work. Never had this problem before and kind of hard to google for "mysql user login without password but has password"..

show grants for 'user'@'%';
+----------------------------------------------------------------------------------------------------+
| Grants for icp@% |
+----------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'user'@'%' IDENTIFIED BY PASSWORD 'password_hash' |
+----------------------------------------------------------------------------------------------------+
There are other privileges for the appropriate databases but they really aren't relevant.

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

thanks,

Keith

-- 
B. Keith Murphy 
Database Administrator 
iContact 
2635 Meridian Parkway, 2nd Floor 
Durham, North Carolina 27713 
blog: 
http://blog.paragon-cs.com 
(o) 919-433-0786 
(c) 850-637-3877