Reset an MD5 hashed password in a MySQL database

To reset a MD5 hashed password in a MySQL database use this SQL – either in phpMyAdmin or command line MySQL. 

This example works exactly for Joomla, but you can change it to match your application’s tables and fields of course.

UPDATE example_users SET password=MD5(‘new password’) WHERE usertype = "Super Administrator";