Difference between revisions of "FAQ I Lost my password"

Revision as of 16:16, 18 January 2025

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.

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

If you lost the root password of MariaDB/MySql

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 (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

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.

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

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.

Linux

Reset the root password of Mysql or MariaB

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

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');

Then validate the change with

mysql> FLUSH PRIVILEGES;
mysql> QUIT;

Type

   /usr/bin/mysqladmin -u root -panewpassword shutdown

Restart your server or only mysql server.