|
|
changing md5 encrypted column (password) in mysql - Mysql
|
Views : 848
|
|
Tagged in : Mysql
|
|
|
Report This Scrap as Inappropriate
We request you to choose the appropriate categroy and subcategory that suits your
objectionable concern about the scrap, So that our team can review and find out whether it violates our Guidelines or the
scrap is not suitable for all viewers.
|
We can use the below steps when you want to change the md5 encrypted password stored in the database (example xx) in the table yy,
select the table to which you want to change the password as,
> use xx;
> show tables;
> select * from yy;
you can check the validity of the password by calling,
> select md5('old-password');
This will show the exact values of the password column
then using "update" query to change the password.
> update yy set password = md5('new-password') where username='somename';
|
|
By - Ramya, On - 2008-03-18 |
|
|
|
