Is there any way to display the passwords in the user table? 2

[peterv12]

I have a few old mysql databases and have forgotten the user passwords. I know that I can delete the old users and recreate them, but is there a way that I can display what their current passwords are in a readable form?

 

[lgarner]

No. But you don't need to delete the users, just update the records with new passwords.

 

[peterv12]

I thought I needed to have the old password to change it. Everything I read said <old password> <new password>. If this isn't the case, would you mind posting the correct syntax for me?
Thanks...

 

[vacunita]

If you have root access to the DB, you can simply issue an Update query on the user table.

UPDATE `user` SET `Password`=PASSWORD("newpass") WHERE `User`="username"

Note the backticks, and the Password function to encode the password.

----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

Behind the Web, Tips and Tricks for Web Development.

http://behindtheweb.blogspot.com/

 

[guelphdad]

The backticks are unnecessary.

Don't forget to run FLUSH PRIVILEGES after changing the password that way. If you don't the new password will not be recognized.