Reset password through PHPMyAdmin

Rate this item
(0 votes)

Need to change a user's password through the MySql database?

Find the user whose password you want to change and press the Edit icon for this row.
A form will display that allows you to edit the password field. Copy the value:

d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199

into the password field and press the Go button. phpMyAdmin should display the message "Affected rows: 1". At this point, the password should be changed to "secret".

Read 624 times