user password change problem

[degreefl]

Hello ,

First , we recently bought sqlyog from you and it's a great tool 🙂 Thx for that …

But we have a little problem with it …

Actually , we're unable to edit mysql user passwords on our servers …

The mysql version we use is 3.23.49 (yeah , it's not the last we know)

To change passwords we have to manually do it from a console or we also use phpMyAdmin and it's working without problems 🙂

We have the same problem on all our servers (4 of them)

I don't know if anyone else had the same problem

Regards

[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