How to change password from Mysql

This is a simple fix for any of you that may be locked out of any type of site admin that uses a mysql database. If you have PHPMyAdmin, this solution will work for you.

Usually you can’t simply replace the password in the database because most site admins use a password hashing algorithm like MD5.

Well that doesn’t have to stop you! Just log into your PHPMyAdmin and go to your users table. Then click on “edit” to edit the row in your table where the password is stored. The trick is to select MD5 in the first box and then put the un-hashed password in the second like in the image below:

pwfix

Leave a Reply

Your email address will not be published. Required fields are marked *