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