Computer Reference: Joomla

Back


  • Category
    Joomla
  • Title
    Recovering a lost super user password
  • Description

    Add a New Super User[edit]

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

    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.
    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 .
    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 to the table.
    Use the SQL query below to add another Administrator account.
    Stop hand nuvola.svg.pngMake sure you match your database 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 to specifically. 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.5, 3.x, 4.x, 5.x

    The table prefix (jos31_) should be replaced with the table prefix in the database tables for your website, EG:  wilbur_

    INSERT INTO `jos31_users`
       (`name`, `username`, `password`, `params`, `registerDate`, `lastvisitDate`, `lastResetTime`)
    VALUES ('Administrator2', 'admin2',
        'd2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199', '', NOW(), NOW(), NOW());
    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 Backend 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 email 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 User group.

    Stop hand nuvola.svg.pngWarning!
    Warning: The password values shown on this page are public knowledge and are only for recovery. Your site may be hacked if you do not change the password to a secure value after logging in.
    The examples above change the password to secret. Two other possible values are shown below:

    - password = "this is the MD5 and salted hashed password"
    ------------------------------------------------------
    - admin  = 433903e0a9d6a712e00251e44d29bf87:UJ0b9J5fufL3FKfCc0TLsYJBh2PFULvT
    - secret = d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199
    - OU812  = 5e3128b27a2c1f8eb53689f511c4ca9e:J584KAEv9d8VKwRGhb8ve7GdKoG7isMm


Back