View source for FAQ I Lost my database password

<!-- 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_le_mot_de_passe_de_ma_base_de_données]]
[[es:FAQ_Tengo_un_problema_en_la_contraseña_de_la_base_de_datos,_que_debo_hacer?]]
<!-- END interlang links -->

[[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.
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 =
== Reset the root password of Mysql ==
* Connect to a Windows administrator account on your computer,<br />
* Go on menu Windows:
    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
    Menu Start -> Execute -> cmd
* Type the following lines to restart MySQL in a particular mode.
    CD C:\dolibarr\bin\mysql\mysql5.0.45\bin 
    C:\dolibarr\bin\mysql\mysql5.0.45\bin\mysqld-nt --skip-grant-tables
* Launch another command line by going to
    Menu Start -> Execute -> cmd
* Type in this new windows 
    CD C:\dolibarr\bin\mysql\mysql5.0.45\bin 
    C:\dolibarr\bin\mysql\mysql5.0.45\bin\mysql -u root
* At the MySQL prompt, type
<source lang="sql">
mysql> UPDATE mysql.user SET Password = PASSWORD('anewpassword') WHERE User = 'root';
mysql> FLUSH PRIVILEGES;
mysql> QUIT;
</source>
* Type 
    C:\dolibarr\bin\mysql\mysql5.0.45\bin\mysqladmin -u root -panewpassword shutdown
* Restart Windows.


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,
* 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('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
* Type the following line to restart MySQL in a particular mode.
    /usr/sbin --skip-grant-tables
* Launch another terminal console.
* Type in this new windows 
    /usr/bin/mysql -u root
* At the MySQL prompt, type
<source lang="sql">
mysql> UPDATE mysql.user SET Password = PASSWORD('anewpassword') WHERE User = 'root';
mysql> FLUSH PRIVILEGES;
mysql> QUIT;
</source>
* Type 
    /usr/bin/mysqladmin -u root -panewpassword shutdown
* 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.

== 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 
    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,
* Ru mysql with root user
     /usr/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 
     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.

= Mac =
== DoliMamp ==
{{ToComplete}}