Changes

m
no edit summary
Line 1: Line 1: −
aaa
+
[[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 =
 +
== DoliWamp ==
 +
* 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.
 +
* 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 (a second time)
 +
* 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.
 +
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.
 +
 
 +
== Dolibarr + XAMPP/Wampserver/EaysPHP... ==
 +
To complete
 +
 
 +
= Linux =
 +
To complete
 +
 
 +
= Mac =
 +
== DoliMamp ==
 +
A compléter