jump to navigation

How to reset Admin password in Joomla June 23, 2011

Posted by Tournas Dimitrios in Joomla-1.6.

This article will show you how to change Joomla’s administrator password with a simple Mysql query . This method is valid  for all versions of Joomla 1.0/1.5 /1.6 .

  • Open phpMyAdmin and select the Joomla database from the drop-down menu at left
  • Click the SQL tab (at the top navigation bar )
  • In the text field write the following SQL query
    UPDATE  ‘jos_users’ SET ‘password’ =MD5(‘Your_New_Passwd’)  WHERE ‘jos_users’ ‘username’ = ‘admin’
    At least you should know your username :)  , and replace ‘admin’ with it .
  • When you are ready , click on the Go button to submit the query
    If everything goes fine , you will receive a “success ” confirmation . Now you should be able to login to Joomla with the new password .

During installation of Joomla , you where asked to customize the prefix of your table-names (for security reasons)  . If the prefix was modified , which I highly recommend , the query to Mysql should reflect yours table-name prefix .


No comments yet — be the first.

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