Mohammedz.com

For Linux and Shell scripting.

Joomla: how to reset the administrator password?

1 Comment


You can’t recover your Joomla password as it’s stored via MD5 method. But, you can reset it via mysql database.

Using phpMyAdmin
*********************
* Select the data base for your Joomla from left combo-box.
* Choose jos_users table and select browse.
* Edit the row where username is admin
* set the password type to MD5 under the function column
* Type in your password and save it.

MySQL commandline
***********************
* Login to your mysql
mysql -uusername -ppassword
* Select database for you joomla
use joomladb
* Change password for admin
UPDATE jos_users SET password=MD5(‘NewPassword’) WHERE username=’admin’;
* quit from mysql

That’s all !!!
~mohammed

Advertisements

One thought on “Joomla: how to reset the administrator password?

  1. thanks for this article.
    download free joomla and wordpress theme in http://sinatheme.ir

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s