How To Solve Joomla Admin Login Problem

If you’re using Joomla, and facing an admin login problem, you’re not alone. The Joomla admin login problem is a huge problem faced by many people, and because there are many causes, here are just some of the more common solutions that you can try.

how to solve joomla admin login problem

Joomla allows Super Administrators to add, edit, and delete users from the User Manager feature in your control panel. However, if you have forgot your password, or if your site has been hacked, or if someone changed your user permissions/password, then you won’t be able to log in as a Super Administrator.

There are workarounds though, and for these methods to work, you’ll need access to your MySQL database.

Force A Change Of Your Password

Using tools such as PhpMyAdmin, you can directly access your MySQL database and change the password of your Super Administrator to something that you know. Follow these steps to change the password of a user to the word “secret”:

  1. In PhpMyAdmin, select your Joomla database in the left-hand menu’s drop-down list.
  2. Once it updates the list of tables, click on the table “jos_users”.
  3. On the right-hand side of the page, click on “Browse” in the top horizontal menu.
  4. From the resulting table, find the user whose password you want to change, and click on the “Edit” icon (it looks like a pencil).
  5. Copy the following value and paste it into the “password” field:


    Click on “Go”.

  6. You should now be able to log in with this user and the new password of “secret”. Once you’re inside the control panel, change the password of this user for security’s sake.

Add a New Super Administrator User For Your Joomla Website

This method creates a new user in your Joomla site.

  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 a SQL query on the selected database. This will display a field called “Run SQL query/queries on database “.
  3. Delete any text in this field and paste in the following and press the Go button.

SQL code (Sites running on Joomla 1.6.xx)

INSERT INTO `jos_users`
(`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`,
`registerDate`, `lastvisitDate`,`activation`,`params`)
VALUES ('40', 'Administrator2', 'admin2', '',
'Super Administrator', 0, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00',"","");
INSERT INTO `jos_user_usergroup_map` (`user_id`,`group_id`) VALUES (40, 8);

SQL code (Sites running on Joomla 1.5.xx)

INSERT INTO `jos_users`
(`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`,
`gid`, `registerDate`, `lastvisitDate`)
VALUES (NULL, 'Administrator2', 'admin2', '',
'Super Administrator', 0, 1, 25, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `jos_core_acl_aro` VALUES (NULL, 'users', LAST_INSERT_ID(), 0, 'Administrator2', 0);
INSERT INTO `jos_core_acl_groups_aro_map` VALUES (25, '', LAST_INSERT_ID());

NOTE: The above code has jos_ as the table name’s prefix (Joomla’s default table name prefix). If you changed this prefix when you first installed Joomla, you will need to change jos_ to the prefix that you used.

After inserting these statements, you’ll be able to log in to Joomla with these new login credentials:

Username: admin2
Password: secret

These login credentials are publicly known and are used for recovery purposes only. After you’ve logged in, it’s crucial that you go to the User Manager panel and change the password and email to prevent unauthorised entry into your Joomla back end.

, , , , , , , , ,

About Site Fixit!

Sam is a professional web designer and web developer. He has over 15 years of experience with web-related technologies, and loves making things work.

View all posts by Site Fixit!

6 Responses to “How To Solve Joomla Admin Login Problem”

  1. Aaron Says:

    works, thanks!


  2. Hene Says:

    doesnot work:(

    #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’,
    ‘d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0′ at line 4


  3. Site Fixit! Says:

    The formatting screwed up some of the apostrophes. Try it now with the updated formatting.


  4. Annie Says:


    Not sure if this is the fix I need – I can login, but can see none of my website. All toolbar buttons have disappeared and can no longer see any of my content. It was all there yesterday, and I haven’t upgraded or installed anything that could cause any changes.

    Kind regards


  5. manali Says:

    Just type “localhost/folder name/joomla/administrator” in url.
    You will be redirected login page of admin.


  6. kavitha Says:

    Sir, I have joomla backend user name problem. I have tried all the possibilities but still showing not a valid user for admin.

    Pl. help me solve the problem


Leave a Reply to manali