Password Problem with User Manager

[lennyh]

Using the User Manager, I'm having a problem setting passwords for new users. Although I set a password, (and the encrypted password appears in the users table along with the new username), the new password does not work with the new username. But if try to connect with the new username using a blank password with the new username, the connect succeeds??

So I'm puzzled.

BTW, thanks for a great tool.

[CalEvans]

It's not supposed to be necessary but have you tried a

FLUSH PRIVILEGES;

just to make sure everything gets committed?

=C=

[lennyh]

Yes, I've tried Flush Privileges. I've also tried completely exiting SQLYog and restarting it. I've also tried stoppping MySQL and restarting it. In all cases the results are the same — I can't login using the new username and its password, but I can login using the new username w/ a blank password.

Here's some more info: After exiting SQLyog, I tried logging in from the mysql cmd line. As it turns out, in this case as well I cannot login with the new username and its password. But once again I can login with the new username and a blank password. So this login anomaly is not restricted to logging in via SQLyog. It's like MySQL itself is not interpreting the password portion of the user table???

I must be overlooking something simple.

Lenny

[lennyh]

I finally figured it out. My problem had nothing to do wtih SQLyog.

My MySQL user table contained a blank username and blank password entry (anonymous entry). The anonymous entry takes precedence over the new entires containing passwords, so entering a password with the new username results in a mismatch.

I'm sure this is an error frequently made. It sure puzzled me for quite a while.

Lenny

[Author]

Posts