Howto change Dolibarr database password

Installing my Dolibarr
,
1

In case anyone ever needs to change the contents of conf.php and especially the passwords here’s how I did it and upgraded from v20.0.2 to v20.0.4

  1. stop and remove dolibarr container
  2. enter mariadb container and connect to the mariadb as root.
  3. change the password for the dolibarr db user (I used this method MariaDB: Change a user password)
  4. select the contents of the user table in the mysql database - here you can see the hashed password for the doli user - which is needed to replicate the mariadb container.
  5. change the password for the configuration of the dolibarr container
  6. move the conf.php file elsewhere, move so you have a backup
  7. start dolibarr container and guide it through the installation process
  8. which will re-create conf.php
  9. remember to create an install.lock file
2 Likes