Re: mysql user password funkyness

From: B. Keith Murphy <kmurphy(at)icontact.com>
Date: Thu Sep 27 2007 - 14:51:19 EDT

Thanks everyone for the replies. The problem revolved around '%' vs 'localhost'. To me, it seems logical that '%' would include localhost..not really true. So, I have it figured out.

thanks,

Keith
----- Original Message -----
From: "B. Keith Murphy" <kmurphy@icontact.com> To: "mysql" <mysql@lists.mysql.com>
Sent: Wednesday, September 26, 2007 10:39:17 PM (GMT-0500) America/New_York Subject: 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.

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 



-- 
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 

Received on Thu Sep 27 14:52:45 2007