Reset administrator password with the help of MySQL

Submitted by deeperdata - 3 years ago

Tested up to CE 1.9. Pretty straight forward.

// From MySQL console or GUI (phpMyAdmin/Workbench)

UPDATE 'admin_user' SET 'password' = MD5('NEWPASSWORD') WHERE 'username' = 'ADMINUSERNAME';
affiliate_link
Learn PHP
comments powered by Disqus
Proudly hosted on Digital Ocean