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";