FAQ I Lost my password: Difference between revisions

Jump to navigation Jump to search

FAQ I Lost my password (view source)

Revision as of 17:40, 18 January 2025

121 bytes added ,  1 year ago
m
→‎If the lost password is that of the Dolibarr admin account
VisualWikitext
Tag: 2017 source edit
Tag: 2017 source edit
 
(8 intermediate revisions by the same user not shown)
Line 2: Line 2:
<!-- You can edit this section but do NOT remove these comments
<!-- You can edit this section but do NOT remove these comments
     Links below will be automatically replicated on translated pages by PolyglotBot -->
     Links below will be automatically replicated on translated pages by PolyglotBot -->
[[fr:FAQ_J'ai_perdu_le_mot_de_passe_de_ma_base_de_données]]
[[fr:FAQ J'ai perdu mon mot de passe]]
[[es:FAQ_Tengo_un_problema_en_la_contraseña_de_la_base_de_datos,_que_debo_hacer?]]
[[es:FAQ Tengo un problema en la contraseña]]
<!-- END interlang links -->
<!-- END interlang links -->


[[Category:FAQ EN]]
[[Category:FAQ EN]]
You may have forget your MariaDB or 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==
==If you lost the root password of MariaDB/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:
Line 35: Line 34:
*Type in this new windows
*Type in this new windows


     CD C:\dolibarr\bin\mysql\mysql5.0.45\bin  
     CD C:\dolibarr\bin\mysql\mysqlx.y.z\bin  
     C:\dolibarr\bin\mysql\mysql5.0.45\bin\mysql -u root
     C:\dolibarr\bin\mysql\mysqlx.y.z\bin\mysql -u root


*At the MySQL prompt, type
*At the MySQL prompt, type


<source lang="sql">
<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
or on a more recent version
mysql> SET PASSWORD FOR 'root@localhost' = PASSWORD('anewpassword');
mysql> SET PASSWORD FOR 'root@localhost' = PASSWORD('anewpassword');
</source>
</syntaxHighlight>
And to take change into account
And to take change into account
<source lang="sql">
<syntaxHighlight lang="sql">
mysql> FLUSH PRIVILEGES;
mysql> FLUSH PRIVILEGES;
mysql> QUIT;
mysql> QUIT;
</source>
</syntaxHighlight>


*Type
*Type
Line 56: Line 55:


*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 the user used by Dolibarr to connect to the database==
*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. The name of user is store into $dolibarr_main_db_user
==Linux==
 
*Save file and quit. It should be ok.
 
*Go in Windows menu
 
    Menu Start - > execute -> CMD
    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
 
<source lang="sql">
mysql> UPDATE mysql.user SET Password = PASSWORD('anewpassword') WHERE User = 'userusedfordatabaseroot';
or on a more recent version
mysql> SET PASSWORD FOR 'userusedfordatabase@localhost' = PASSWORD('anewpassword');
</source>
The to take the change into account.
<source lang="sql">
mysql> FLUSH PRIVILEGES;
mysql> QUIT;
</source>
 
Note that you may need to change the "localhot" with the ip of the server if the database is onto another server.
 
=Linux=
==If you lost the root password of Mysql or MariaB==


*Connect to a terminal console with user roor.
*Connect to a terminal console with user roor.
Line 110: Line 73:
*Type in this new windows
*Type in this new windows


    /usr/bin/mysql -u root
 


*At the MySQL prompt, type
*At the MySQL prompt, type


<source lang="sql">
<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
or on a more recent version
mysql> SET PASSWORD FOR 'root@localhost' = PASSWORD('anewpassword');
mysql> SET PASSWORD FOR 'root@localhost' = PASSWORD('anewpassword');
</source>
</syntaxHighlight>
Then validate the change with
Then validate the change with
<source lang="sql">
<syntaxHighlight lang="sql">
mysql> FLUSH PRIVILEGES;
mysql> FLUSH PRIVILEGES;
mysql> QUIT;
mysql> QUIT;
</source>
</syntaxHighlight>


*Type
*Type
Line 133: Line 96:
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 the user used by Dolibarr to connect to the database==
 
= Reset the password used by Dolibarr to access the database =


*Go into
*Go into


     htdocs\conf  
     C:\dolibarr\www\dolibarr\htdocs\conf  


*Edit file conf.php to change variable
*Edit file conf.php to change variable


     $dolibarr_main_db_pass
     $dolibarr_main_db_pass
with value of the new password.
 
with value of the new password. The name of user is store into $dolibarr_main_db_user


*Save file and quit. It should be ok.
*Save file and quit. It should be ok.


If Dolibarr use another MySQL user than root,
*Go into the MariaDB prompt from a terminal:
 
*Ru mysql with root user


    /usr/bin/mysql -u root -ppassword
    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
*At the MySQL prompt, type


<source lang="sql">
<syntaxHighlight lang="sql">
mysql> UPDATE mysql.user SET Password = PASSWORD('anothernewpassword') WHERE User = 'userusedbydolibarr';
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
Note that you may need to change the "localhot" with the ip of the server if the database is onto another server.


    htdocs\conf


*edit file conf.php and search lines
= Resetting the password of a Dolibarr application user account =
== 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.


    $dolibarr_main_db_user="xxx";
== If the lost password is that of the Dolibarr admin account ==
    $dolibarr_main_db_pass="yyy";
Log in to the Dolibarr mysql database and modify the "pass" field of the login with which you want to connect.
Replace xxx and yyy by real values.
<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/62171...62197"

Navigation menu