Come si fa a recuperare o reimpostare la password di amministratore?

From Joomla! Documentation

This page is a translated version of the page How do you recover or reset your admin password? and the translation is 44% complete.

Other languages:
Deutsch • ‎Ελληνικά • ‎English • ‎español • ‎eesti • ‎فارسی • ‎français • ‎italiano • ‎Nederlands • ‎português • ‎português do Brasil • ‎русский • ‎ไทย • ‎Türkçe • ‎中文(中国大陆)‎ • ‎中文(台灣)‎
Joomla! 1.5 Recupero della Password

Questa pagina è solo per Joomla! 2.5 e versioni superiori. Se stai ancora utilizzando Joomla! 1.5  le istruzioni possono essere trovate qui.

Generalmente, è possibile aggiungere, modificare ed eliminare gli utenti e le password dal back-end. Per fare questo, è necessario accedere con un utente del gruppo Super Administrator.

In alcuni casi, questo potrebbe non essere possibile. Ad esempio, il sito potrebbe essere stato "hackerato" e le password degli utenti potrebbero essere state cambiate. O forse la persona che conosceva le password non è più disponibile. O forse hai dimenticato la password utilizzata.

In questi casi, è ancora possibile modificare il database di Joomla! in modo da poter accedere nuovamente come Super Amministratore. Questi sono i possibili metodi disponibili.

Metodo 1: file configuration.php

Se hai accesso al file sul server configuration.php dell'installazione di Joomla, puoi recuperare la password utilizzando il metodo riportato di seguito.

1. Utilizza un programma FTP per connetterti al tuo sito. Trova il file configuration.php e guarda le autorizzazioni del file. Se le autorizzazioni sono 444 o qualche altro valore, modifica le autorizzazioni del file configuration.php a 644. Questo aiuterà a prevenire problemi durante il caricamento delle modifiche del file configuration.php che faremo più avanti.

2. Scarica il file di configurazione.

3. Apri il file configuration.php appena scaricato con un editor di testo come notepad++ e aggiungi questa riga:

public $root_user='myname';

in fondo alla lista dove myname è un nome di un utente con privilegi di amministratore di cui conosci la password. Puoi usare anche un utente con livello Author o superiore.

4. Salva il file configuration.php e caricarlo nuovamente sul sito. Puoi lasciare le autorizzazioni del file configuration.php a 644.

Questo utente diverrà un super amministratore temporaneo.

5. Accedi al back-end e modifica la password dell'utente amministratore di cui non si dispone la password o crea un nuovo super utente admin. Se crei un nuovo utente, considera che vorresti bloccare o cancellare il vecchio utente a seconda delle circostanze.

6. When finished, make sure to use the "Click here to try to do it automatically" link that appears in the alert box to remove the line that was added to the configuration.php file. If using the link was not successful, then go back and delete the added line from your configuration.php file using a text editor. Upload the configuration.php file back to the site.

7. Using your FTP program verify the file permissions of the configuration.php file, they should be 444. If you manually removed the added line, then change the file permissions on the configuration.php file to 444.

If you have no users who know their passwords and you can't utilize front end registration you may need to make a change in your database as outlined below in this document.


Method 2: Direct Editing of Database

If the methods above did not work, you have two other options, both of which require working with the MySQL database directly.

Change the Password in the Database

If the admin user is still defined, the simplest option is to change the password in the database to a known value. This requires that you have access to the MySQL database using phpMyAdmin or another client.

Stop hand nuvola.svg.png
Make sure you change your password once you regain access

These instructions show how to manually change a password to the word - "secret"


  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. Find and click on the table with "_users" appended in the list of tables (note: you may have a prefix that is not jos_, simply go to the _users table for your prefix).
  3. Click on the "Browse" button in the top toolbar. This will show all of the users that are set up for this site.
  4. Find the user whose password you want to change and press the Edit icon for this row.
  5. A form will display that allows you to edit the password field. Copy the value
    d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199
    
    into the password field and press the Go button. phpMyAdmin should display the message "Affected rows: 1". At this point, the password should be changed to "secret".
  6. Log in with this user and password and change the password of this user to a secure value. Check all of the users using the User Manager to make sure they are legitimate. If you have been hacked, you may want to change all of the passwords on the site.

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.


Stop hand nuvola.svg.png
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 Joomla 2.5 Joomla 3.1

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.

Stop hand nuvola.svg.png
Warning!

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. Be sure you 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