Forefront IT Services Ltd

How to reset Joomla admin password from MySQL Command Line

phpMyAdmin is not always available, but if you have access to the console, it can be done with a simple command line.

run mysql (you will probably need to run mysq -ppassword

use the 'use' command to switch to the correct database (use database name;)

then use the following command to reset the 'admin' password to 'admin'

UPDATE `jos_users` SET `password` = "21232f297a57a5a743894a0e4a801fc3" WHERE `jos_users`.`username` = "admin";

this assumes you using the default table prefix of 'jos_' ! Change as required.

 

 

 

Get In Touch

Forefront IT Services
The Old Haybarn
Rosebery Mews
Mentmore
Leighton Buzzard
Bedfordshire
LU7 0UE

Tel: 0845 686 3348
Email: info@ffits.co.uk


You are here  :