Joomla reset password using mysql command line

January 2, 2015 at 3:53 pm (last edited January 2, 2015 at 4:37 pm)

Means you have a root previlegies:

mysql database_name;

mysql> update jos_users set password = MD5("strong_password_here") where id = 111;

id = 111 – must match to the account for which you want to reset password

Done!