Dolibarr ERP CRM Wiki

FAQ I Lost my password: Difference between revisions

Page

FAQ I Lost my password (view source)

Revision as of 17:40, 18 January 2025

758 bytes added ,  1 year ago
m
→‎If the lost password is that of the Dolibarr admin account
VisualWikitext
Tag: 2017 source edit
 
(18 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<!-- BEGIN origin interlang links -->
<!-- You can edit this section but do NOT remove these comments
    Links below will be automatically replicated on translated pages by PolyglotBot -->
[[fr:FAQ J'ai perdu mon mot de passe]]
[[es:FAQ Tengo un problema en la contraseña]]
<!-- END interlang links -->
[[Category:FAQ EN]]
[[Category:FAQ EN]]
You may have forget your MySQL database password or for an unknown reason, it does not works anymore. This is a solution to restore this.
It may happen that you forget your password or that for an unknown reason it no longer works, here is the solution to regain control depending on the 3 types of passwords concerned.
 
= Resetting MariaDB/MySQL database root password =
This FAQ speak about a MySQL database administrator password problem and not about the lost of the password of a Dolibarr account used to work on Dolibarr.  
This FAQ speak about a MySQL database administrator password problem and not about the lost of the password of a Dolibarr account used to work on Dolibarr.  


= With Microsoft Windows =
==With Microsoft Windows==
== Reset the root password of Mysql ==
*Connect to a Windows administrator account on your computer,<br />
* Connect to a Windows administrator account on your computer,<br />
*Go on menu Windows:
* Go on menu Windows:
 
     Menu Start -> parameters -> Setup panel -> Administration tools -> Services.
     Menu Start -> parameters -> Setup panel -> Administration tools -> Services.
* Find the service MySQL '''doliwampmysql''' into the list and stop it (we assume you installed DoliWamp. Name may differs if using a manuel installation of MySql).
 
* Launch the command line command by going to
*Find the service MySQL '''doliwampmysql''' into the list and stop it (we assume you installed DoliWamp. Name may differs if using a manuel installation of MySql).
*Launch the command line command by going to
 
     Menu Start -> Execute -> cmd
     Menu Start -> Execute -> cmd
* Type the following lines to restart MySQL in a particular mode.
 
*Type the following lines to restart MySQL in a particular mode.
 
     CD C:\dolibarr\bin\mysql\mysql5.0.45\bin  
     CD C:\dolibarr\bin\mysql\mysql5.0.45\bin  
     C:\dolibarr\bin\mysql\mysql5.0.45\bin\mysqld-nt --skip-grant-tables
     C:\dolibarr\bin\mysql\mysql5.0.45\bin\mysqld-nt --skip-grant-tables
* Launch another command line by going to
 
*Launch another command line by going to
 
     Menu Start -> Execute -> cmd
     Menu Start -> Execute -> cmd
* Type in this new windows  
 
     CD C:\dolibarr\bin\mysql\mysql5.0.45\bin  
*Type in this new windows
     C:\dolibarr\bin\mysql\mysql5.0.45\bin\mysql -u root
 
* At the MySQL prompt, type
     CD C:\dolibarr\bin\mysql\mysqlx.y.z\bin  
<source lang="sql">
     C:\dolibarr\bin\mysql\mysqlx.y.z\bin\mysql -u root
 
*At the MySQL prompt, type
 
<syntaxHighlight lang="sql">
mysql> UPDATE mysql.user SET Password = PASSWORD('anewpassword') WHERE User = 'root';
mysql> UPDATE mysql.user SET Password = PASSWORD('anewpassword') WHERE User = 'root';
or on a more recent version
mysql> SET PASSWORD FOR 'root@localhost' = PASSWORD('anewpassword');
</syntaxHighlight>
And to take change into account
<syntaxHighlight lang="sql">
mysql> FLUSH PRIVILEGES;
mysql> FLUSH PRIVILEGES;
mysql> QUIT;
mysql> QUIT;
</source>
</syntaxHighlight>
* Type  
 
*Type
 
     C:\dolibarr\bin\mysql\mysql5.0.45\bin\mysqladmin -u root -panewpassword shutdown
     C:\dolibarr\bin\mysql\mysql5.0.45\bin\mysqladmin -u root -panewpassword shutdown
* Restart Windows.


*Restart Windows.


You should now be able to access your MySQL database, you can now tell to Dolibarr to use the new password.
You should now be able to access your MySQL database, you can now tell to Dolibarr to use the new password.


== Change dolibarr config file to use new password ==
If you use the root user also to allow Dolibarr to connect to your database (not recommanded but why not)
* Go into
    C:\dolibarr\www\dolibarr\htdocs\conf
* Edit file conf.php to change variable
    $dolibarr_main_db_pass
with value of the new password.
* Save file and quit. It should be ok.


If Dolibarr use another MySQL user than root,
==Linux==
* Go in Windows menu
 
    Menu Start - > execute -> CMD
*Connect to a terminal console with user roor.
    cd C:\dolibarr\bin\mysql\mysql5.0.45\bin\
*Stop Mysql:
    C:\dolibarr\bin\mysql\mysql5.0.45\bin\mysql -u root -ppassword
* At the MySQL prompt, type
<source lang="sql">
mysql> UPDATE mysql.user SET Password = PASSWORD('anothernewpassword') WHERE User = 'userusedbydolibarr';
mysql> FLUSH PRIVILEGES;
mysql> QUIT;
</source>
* Go into
    C:\dolibarr\www\dolibarr\htdocs\conf
* edit file conf.php and search lines
    $dolibarr_main_db_user="xxx";
    $dolibarr_main_db_pass="yyy";
Replace xxx and yyy by real values.


= Linux =
== Reset the root password of Mysql ==
* Connect to a terminal console with user roor.
* Stop Mysql:
     /usr/sbin/mysql stop
     /usr/sbin/mysql stop
* Type the following line to restart MySQL in a particular mode.
 
*Type the following line to restart MySQL in a particular mode.
 
     /usr/sbin --skip-grant-tables
     /usr/sbin --skip-grant-tables
* Launch another terminal console.
 
* Type in this new windows  
*Launch another terminal console.
    /usr/bin/mysql -u root
*Type in this new windows
* At the MySQL prompt, type
 
<source lang="sql">
 
 
*At the MySQL prompt, type
 
<syntaxHighlight lang="sql">
mysql> UPDATE mysql.user SET Password = PASSWORD('anewpassword') WHERE User = 'root';
mysql> UPDATE mysql.user SET Password = PASSWORD('anewpassword') WHERE User = 'root';
or on a more recent version
mysql> SET PASSWORD FOR 'root@localhost' = PASSWORD('anewpassword');
</syntaxHighlight>
Then validate the change with
<syntaxHighlight lang="sql">
mysql> FLUSH PRIVILEGES;
mysql> FLUSH PRIVILEGES;
mysql> QUIT;
mysql> QUIT;
</source>
</syntaxHighlight>
* Type  
 
*Type
 
     /usr/bin/mysqladmin -u root -panewpassword shutdown
     /usr/bin/mysqladmin -u root -panewpassword shutdown
* Restart your server or only mysql server.
 
*Restart your server or only mysql server.


You should now be able to access your MySQL database, you can now tell to Dolibarr to use the new password.
You should now be able to access your MySQL database, you can now tell to Dolibarr to use the new password.


== Change Dolibarr config file to use new password ==
 
If you use the root user also to allow Dolibarr to connect to your database (not recommanded but why not)
= Reset the password used by Dolibarr to access the database =
* Go into  
 
     htdocs\conf  
*Go into
* Edit file conf.php to change variable
 
     C:\dolibarr\www\dolibarr\htdocs\conf  
 
*Edit file conf.php to change variable
 
     $dolibarr_main_db_pass
     $dolibarr_main_db_pass
with value of the new password.
* Save file and quit. It should be ok.


If Dolibarr use another MySQL user than root,
with value of the new password. The name of user is store into $dolibarr_main_db_user
* Ru mysql with root user
 
    /usr/bin/mysql -u root -ppassword
*Save file and quit. It should be ok.
* At the MySQL prompt, type
 
<source lang="sql">
*Go into the MariaDB prompt from a terminal:
mysql> UPDATE mysql.user SET Password = PASSWORD('anothernewpassword') WHERE User = 'userusedbydolibarr';
 
    With Linux:  /usr/bin/mysql -u root
    With Windows: Menu Start - > execute -> CMD then cd C:\dolibarr\bin\mysql\mysql5.0.45\bin\;  C:\dolibarr\bin\mysql\mysql5.0.45\bin\mysql -u root -ppassword
 
*At the MySQL prompt, type
 
<syntaxHighlight lang="sql">
mysql> UPDATE mysql.user SET Password = PASSWORD('anewpassword') WHERE User = 'userusedfordolibarrdatabase';
or on a more recent version
mysql> SET PASSWORD FOR 'userusedfordolibarrdatabase@localhost' = PASSWORD('anewpassword');
</syntaxHighlight>
The to take the change into account.
<syntaxHighlight lang="sql">
mysql> FLUSH PRIVILEGES;
mysql> FLUSH PRIVILEGES;
mysql> QUIT;
mysql> QUIT;
</source>
</syntaxHighlight>
* Go into
 
    htdocs\conf
Note that you may need to change the "localhot" with the ip of the server if the database is onto another server.
* edit file conf.php and search lines
 
    $dolibarr_main_db_user="xxx";
 
    $dolibarr_main_db_pass="yyy";
= Resetting the password of a Dolibarr application user account =
Replace xxx and yyy by real values.
== If you have another account to access the application and it is admin ==
Log in with it. Then go to the user's profile whose password you need to change. Modify the profile to force a new password.
 
== If the lost password is that of the Dolibarr admin account ==
Log in to the Dolibarr mysql database and modify the "pass" field of the login with which you want to connect.
<syntaxHighlight lang="sql">
mysql> USE nomdelabaseolibar;
mysql> UPDATE llx_user SET pass = 'atemporarypasswod' WHERE login ='loginuserbloque';
</syntaxHighlight>


= Mac =
Try to connect then modify your password from your user profile. This will clear the unencrypted temporary password in order to store your new encrypted password in this table.
== DoliMamp ==
{{ToComplete}}
Retrieved from "https://wiki.dolibarr.org/index.php/Special:MobileDiff/31464...62197"