How to reset my Joomla administrator password?

You can reset your Joomla administrator's password through the script's MySQL Database.

The most convenient way to manage the database is through the phpMyAdmin tool. Go to your cPanel and click on phpMyAdmin in the Databases box.

Once in the phpMyAdmin select the Joomla's database from the drop-down menu at left. The page will refresh and the database's tables will be displayed on it. Open the SQL tab (look at the top navigation bar).

In the text field write the following SQL query:

UPDATE `jos_users` SET `password` = MD5( 'new_password' ) WHERE `jos_users`.`username` = "admin_username" LIMIT 1 ;

"new_password" - replace this with the new password you wish to use.
"admin_username" - replace this with the username the password should be updated for.

Once you are ready, click on the GO button to submit the query. If everything goes fine without errors, you should be able to login to Joomla with the new password.

Hjälpte svaret dig?

 Skriv ut denna artikeln

Läs även

How do I connect to MySQL through PHP?

Use the following outline to connect and begin querying the MySQL server from within your PHP...

Optimal PHP settings for shared and reseller hosting.

Note: We can't change following PHP settings. PHP has been configured to use the following...

After I install osCommerce I get sessions directory error ?

Set this in both your admin/includes/configure.php and catalog/includes/configure.php: From:...

Can you disable or turn off php Safe Mode?

No, we cannot disable php safe mode. All our servers have php safe mode enabled due to security...

How to reset your password for Oscommerce.

osCommerce uses .htaccess and .htpasswd format files to manage the protection on the admin...