Blog

latest News, Update, Tutorials and much more
2 minutes reading time (307 words)

How to reset Joomla admin password

Add a New Super Administrator User

If changing the password won't work, or you aren't sure which user is a member of the Super Administrator group, you can use this method to create a new user.

  1. Navigate to phpMyAdmin and select the database for the Joomla! site in the left-hand drop-down list box. This will show the database tables on the left side of the screen.
  2. Press the "SQL" button in the toolbar to run an SQL query on the selected database. This will display a field called "Run SQL query/queries on database <your database>".
  3. Delete any text in this field and copy and paste the following query below and press the Go button to execute the query and add the new Administrator user to the table.
  4. Use the SQL query below to add another administrator account.
Make sure you match your db table prefix!

The following code uses jos31_ as the table name prefix which is only an example table prefix. The prefix when you first installed Joomla is RANDOM or what you set it specifically too. You will need to change all occurrences of jos31_(your install set prefix) found in the code below to the prefix your installation is using.

 

SQL code for use with Joomla 2.x | 3.x

INSERT INTO `jos31_users`
   (`name`, `username`, `password`, `params`)
VALUES ('Administrator2', 'admin2',
    'd2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199', '');
INSERT INTO `jos31_user_usergroup_map` (`user_id`,`group_id`)
VALUES (LAST_INSERT_ID(),'8');

 

At this point, you should be able to log into the back end of Joomla! with the username of "admin2" and password of "secret". After logging in, go to the User Manager and change the password to a new secure value and add a valid e-mail address to the account. If there is a chance you have been "hacked", be sure to check that all users are legitimate, especially any members of the Super Administrator group.

How to change a websites php memory_limit
Load a module inside an article
 
sepratord j1

 

Schedule a
Free Consultation

Sometimes a relationship needs a little nudge to help it grow.
Tell us a few things about yourself and we will show you a lot more about us.

Please type your full name.
Invalid email address.
Invalid Input
Invalid Input
Invalid Input

sepratord j1