MySQL Forums
Forum List  »  Security

Re: setting mysql passwords securely
Posted by: Olivier Bonvalet
Date: September 08, 2005 06:58AM

Hello,

you can directly update the "mysql.users" table, setting the "encrypted" password.

For example. Your user want the password "toto", it give you the encrypted version (wich is '3c90ae60272fb624' under mySQL 4.0).

And you, you have to execute : update mysql.users set password='3c90ae60272fb624' where user='your_user' and host='what_you_want';



but.... Your user have to be able to "crypt" his password to give it to you :)

From mySQL, he've to execute : select password( 'toto');



I hope this will help you.

Options: ReplyQuote


Subject
Views
Written By
Posted
3790
August 02, 2005 11:53AM
Re: setting mysql passwords securely
2559
September 08, 2005 06:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.