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.

這篇文章有幫助嗎?

 列印本文

Also Read

After I install osCommerce I get sessions directory error ?

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

Fatal PHP Memory Limit Error

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 30720 bytes) in...

My PHP program tells me it can't access the database and gives an error message ?

MySQL - When you create a new database you have to specify a database name. Then you create a...

How to setup custom php.ini file?

What is php.ini?PHP.ini is very important configuration file for PHP that is used to customize...

Optimizing Wordpress on Shared Hosting

Wordpress blogs can be extremely resource intensive if you happen to experience a surge in...