[nicpon]

Hello,
I have question about MD5. I have some passwords stored in mysql database and my boss wants me to change them hehe.The thing is that it has to be done fast and there no website application to change it.So my question is there a way to change the vaule of the password field in mysql database coded in MD5?

Michael

[NeverMind]

Code:

UPDATE table_1 SET password_field=MD5(password_field);

excute this SQL query using phpMyAdmin for example but of course you have to change table_1 to your table name and password_field to your password field name

[NeverMind]

NOTE: this query will encrypt ALL the records which are under the colmun password_field in your database with the MD5() alogarithm ..
just to make sure that you know what you are doing ..

[nicpon]

Originally Posted by NeverMind

Code:

UPDATE table_1 SET password_field=MD5(password_field);

excute this SQL query using phpMyAdmin for example but of course you have to change table_1 to your table name and password_field to your password field name

In this piece of query MD5(password_field) what is password_field?Is it a password field name or the password i have to put in b\c if i have two password field names it doesnt make sens ??

Michael

[nicpon]

Originally Posted by nicpon

In this piece of query MD5(password_field) what is password_field?Is it a password field name or the password i have to put in b\c if i have two password field names it doesnt make sens ??

Michael

Ok i thought about what you have written before and it make sens.What if i would like to change only certain rows and not all of them or what will happen to those that are already in MD5?Is the query going to change them again??
Michael