FAQ I Lost my password

From Dolibarr ERP CRM Wiki
Revision as of 11:38, 24 February 2010 by Eldy (talk | contribs) (→‎DoliWamp)
Jump to navigation Jump to search

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,
  • 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
  • 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
mysql> UPDATE mysql.user SET Password = PASSWORD('anewpassword') WHERE User = 'root';
mysql> FLUSH PRIVILEGES;
mysql> QUIT;
  • 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
mysql> UPDATE mysql.user SET Password = PASSWORD('anothernewpassword') WHERE User = 'userusedbydolibarr';
mysql> FLUSH PRIVILEGES;
mysql> QUIT;
  • 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