user password change problem

[Shadow]

What do you mean by “unable to edit mysql user passwords on our servers?” Do you get any error message, or everythings seems to be ok until someone tries to log in with the new password? BTW which version of SQLyog do you use?

The catch might be that SQLyog doesn't use the GRANT/REVOKE/SET PASSWORD commands for administering users. It issues explicit INSERT/UPDATE/DELETE commands instead. If the user that tries to change the password of other users does not have the necessary rights on MySql db, then the operation will fail. (For changing passwords other than yours, you need INSERT/UPDATE rights on the user table anyhow.)

[degreefl]

welll … huh … nevermind

sqlyog 3.52

The problem was , wa had a different value generated for passwords when using sqlyog than when using something else …the result was we had to create the user in sqlyog , with password , then go in phpmyadmin or console to just set a correct password so that user could logon …

no error message was ever generated untill user logon …

but now we just tested again to put an example here and guess what … it's working without any problem (gah)

so I guess we were all drunk or something …

you may close this post huh

😮

“it must be user error”

sorry for the useless post guys

[Shadow]

I face the same problem all the time: I figure something doesn't work, and then looking deeper into the matter I find out that it was entirely my fault…

[Author]

Posts