# Database passwords with DoliDeb Installation are?

**URL:** <https://www.dolibarr.org/forum/t/database-passwords-with-dolideb-installation-are/14325>\
**Category:** Installing my Dolibarr\
**Created:** [July 20, 2016, 9:37am UTC](https://www.dolibarr.org/forum/t/database-passwords-with-dolideb-installation-are/14325 "2016-07-20T09:37:10Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![holger3208](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/h/3e96dc/32.png) [@holger3208](https://www.dolibarr.org/forum/u/holger3208)\
**Post date:** [July 20, 2016, 9:37am UTC](https://www.dolibarr.org/forum/t/database-passwords-with-dolideb-installation-are/14325/1 "2016-07-20T09:37:10Z")

</div>

Hello,

I tried to install the last DoliDeb Version with Dolibarr 3.5.8 on my new ubuntu System.  
As you can see at the screenshots below everything goes fine, till the question of Superuser and Password.

The Login name for database owner is given from the system named “dolibarr”

My questions are:  
- What is the password for the database owner dolibarr?  
- What is the right entry for the superuser name and password?

The DoliDeb installation package must set these entrys, but I couldn`t find it…  
Or is there a way to reset it? Thank you!

 ![1.png](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/1/130d5ab1a5d44147062e69b268fa4c00020c3fcf.png)

 ![2.png](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/6/67ab6e0c5edcf9c9ad32de1667aebdd51bdf1c28.png)

 ![3.png](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/4/420db0d14882977a6441030b166df340d5225510.png)

 ![4.png](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/1/16b5045e54b3dac7a26b98ad5620582bc5ef7bba.png)

 ![5.png](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/c/cf70539479788f54a8f5db2aaf02966123553058.png)

 ![6.png](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/5/5ce3008020363be222db41c515d1e73eadc8a350.png)

---

<div class="post-metadata">

**Author:** ![holger3208](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/h/3e96dc/32.png) [@holger3208](https://www.dolibarr.org/forum/u/holger3208)\
**Post date:** [July 25, 2016, 7:00pm UTC](https://www.dolibarr.org/forum/t/database-passwords-with-dolideb-installation-are/14325/2 "2016-07-25T19:00:43Z")

</div>

No idea?

---

<div class="post-metadata">

**Author:** ![eldy](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/eldy/32/12_2.png) [@eldy](https://www.dolibarr.org/forum/u/eldy)\
**Post date:** [July 26, 2016, 10:39pm UTC](https://www.dolibarr.org/forum/t/database-passwords-with-dolideb-installation-are/14325/3 "2016-07-26T22:39:05Z")

</div>

Hi,  
When you are on page related to screenshot you sent, you must fill the last field (root password) with the root password of mysql.  
This password was set when mysql was installed the first time.

If you don’t remind it, you can reset it following tutorial  
[https://wiki.dolibarr.org/index.php/FAQ\_I\_Lost\_my\_database\_password#Reset\_the\_root\_password\_of\_Mysql\_2](https://wiki.dolibarr.org/index.php/FAQ_I_Lost_my_database_password#Reset_the_root_password_of_Mysql_2)

---

<div class="post-metadata">

**Author:** ![Peter\_A\_Gebhardt](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/peter_a_gebhardt/32/377_2.png) [@Peter\_A\_Gebhardt](https://www.dolibarr.org/forum/u/Peter_A_Gebhardt)\
**Post date:** [July 27, 2016, 12:02am UTC](https://www.dolibarr.org/forum/t/database-passwords-with-dolideb-installation-are/14325/4 "2016-07-27T00:02:47Z")

</div>

Maybe this leads to a solution (in German):

[https://blog.v-gar.de/2016/07/solved-error-1698-28000-in-mysqlmariadb/](https://blog.v-gar.de/2016/07/solved-error-1698-28000-in-mysqlmariadb/)

Best regards

---

<div class="post-metadata">

**Author:** ![holger3208](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/h/3e96dc/32.png) [@holger3208](https://www.dolibarr.org/forum/u/holger3208)\
**Post date:** [July 27, 2016, 6:17am UTC](https://www.dolibarr.org/forum/t/database-passwords-with-dolideb-installation-are/14325/5 "2016-07-27T06:17:33Z")

</div>

> [@eldy](#):
>
> Hi,  
> …  
> This password was set when mysql was installed the first time.

That is the point. I’ve never set a password :unhappy:  
I have choosen the Dolideb Installation and that is including mysql Server, php and apache.  
The ubuntu client is new installed and Dolideb Installation was the first I’ve done.

That is why I find it strange… but it seems to me to go this way, or the one casati wrote down below.  
I thought it must be a bug inside Dolideb that the password is preset and someone shoud know that.

---

<div class="post-metadata">

**Author:** ![holger3208](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/h/3e96dc/32.png) [@holger3208](https://www.dolibarr.org/forum/u/holger3208)\
**Post date:** [July 27, 2016, 6:59am UTC](https://www.dolibarr.org/forum/t/database-passwords-with-dolideb-installation-are/14325/6 "2016-07-27T06:59:28Z")

</div>

> [@eldy](#):
>
> Hi,  
> [FAQ I Lost my database password - Dolibarr ERP CRM Wiki](https://wiki.dolibarr.org/index.php/FAQ_I_Lost_my_database_password#Reset_the_root_password_of_Mysql_2)

That way won’t work for me…  
File or folder not found.

![Bildschirmfotovom2016-07-2708-56-04.png](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/1/175cef43e86eb33af84111dec864a7ae499264f0.png)

---

<div class="post-metadata">

**Author:** ![ndrosis](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ndrosis/32/231_2.png) [@ndrosis](https://www.dolibarr.org/forum/u/ndrosis)\
**Post date:** [July 27, 2016, 11:24am UTC](https://www.dolibarr.org/forum/t/database-passwords-with-dolideb-installation-are/14325/7 "2016-07-27T11:24:36Z")

</div>

sudo cat /etc/mysql/debian.cnf

---

<div class="post-metadata">

**Author:** ![Lelio\_it](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/l/bc8723/32.png) [@Lelio\_it](https://www.dolibarr.org/forum/u/Lelio_it)\
**Post date:** [July 27, 2016, 1:11pm UTC](https://www.dolibarr.org/forum/t/database-passwords-with-dolideb-installation-are/14325/8 "2016-07-27T13:11:09Z")

</div>

In my instalation of Mysql the preset password for the root user was “admin” … try

---

<div class="post-metadata">

**Author:** ![alphil](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/alphil/32/2769_2.png) [@alphil](https://www.dolibarr.org/forum/u/alphil)\
**Post date:** [July 27, 2016, 10:04pm UTC](https://www.dolibarr.org/forum/t/database-passwords-with-dolideb-installation-are/14325/9 "2016-07-27T22:04:40Z")

</div>

You must be root

![Captura.png](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/1/103d60ba0a1bec7d2929183a370b6317c6e0feb6.png)

---

<div class="post-metadata">

**Author:** ![holger3208](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/h/3e96dc/32.png) [@holger3208](https://www.dolibarr.org/forum/u/holger3208)\
**Post date:** [July 28, 2016, 5:23am UTC](https://www.dolibarr.org/forum/t/database-passwords-with-dolideb-installation-are/14325/10 "2016-07-28T05:23:16Z")

</div>

> [@Lelio\_it](#):
>
> In my instalation of Mysql the preset password for the root user was “admin” … try

Sadly no :unhappy:

> [@alphil](#):
>
> You must be root

Yes, normally I do this with sudo su. Thanks :happy:

> [@ndrosis](#):
>
> sudo cat /etc/mysql/debian.cnf

I get the default passwort from the user debian-sys-maint, with these results:

root@aspire-6930G:/home/holger# cat /etc/mysql/debian.cnf

# Automatically generated for Debian scripts. DO NOT TOUCH!

[client]  
host = localhost  
user = debian-sys-maint  
password = 7hh9xxxxxxxxxxxx  
socket = /var/run/mysqld/mysqld.sock  
[mysql\_upgrade]  
host = localhost  
user = debian-sys-maint  
password = 7hh9xxxxxxxxxxxx  
socket = /var/run/mysqld/mysqld.sock

When I put this user and password in the installation fields (Database server - Superuser access) I can go on! :laugh:  
But isn’t that user only for maintance?

Can I go on with that user, or better still find out the pw for root?  
However it stucks on the last page, as I show you on the screenshots… :blink:

 ![1_2016-07-28.png](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/5/5395669e139ea8cbd1c4ec4c0848cd3bb71b2dff.png)

(Pic 2 appears after the input of debian-sys-maint and the pw)

 ![2_2016-07-28.png](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/3/397a0dd58e1cf6cbb7a594dc02417a011b19fef2.png)

 ![3_2016-07-28.png](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/9/997926c2d1b4681265ead7c5c5a4d2daffff1af3.png)

Maybe I should install everything new and try your suggestions from the beginning… I’m not sure if I “break” something inside the software…

---

<div class="post-metadata">

**Author:** ![michaelagiles](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/m/ce73a5/32.png) [@michaelagiles](https://www.dolibarr.org/forum/u/michaelagiles)\
**Post date:** [January 8, 2017, 7:56pm UTC](https://www.dolibarr.org/forum/t/database-passwords-with-dolideb-installation-are/14325/11 "2017-01-08T19:56:14Z")

</div>

Good Afternoon!  
I have the same issue - new install of Debian. New to Debian and Linux and Dolibarr!  
I have been trying to install Dolideb and get to the same point as several others in this thread.  
Databas Server - Superuser access  
Login:  
Password:

Access denied for user “xxxx@localhost” using password: YES  
etc. etc.

Someone suggested i needed the password from MySql installation. To my knowledge, I have not installed MySql - as far as I understand, this is part of this package installation.

Any help for this?

Thanks!  
MAG

---

<div class="post-metadata">

**Author:** ![holger3208](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/h/3e96dc/32.png) [@holger3208](https://www.dolibarr.org/forum/u/holger3208)\
**Post date:** [January 8, 2017, 10:11pm UTC](https://www.dolibarr.org/forum/t/database-passwords-with-dolideb-installation-are/14325/12 "2017-01-08T22:11:15Z")

</div>

Hey MAG,  
my problem was solved when Ubuntu 14.04 was installed!  
It didn´t work with the 16.04 version…

Last week I´ve installed it with the Ubuntu Server Version of 16.04 and that worked perfect.  
Sorry, no better news.

---

<div class="post-metadata">

**Author:** ![michaelagiles](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/m/ce73a5/32.png) [@michaelagiles](https://www.dolibarr.org/forum/u/michaelagiles)\
**Post date:** [January 10, 2017, 11:22pm UTC](https://www.dolibarr.org/forum/t/database-passwords-with-dolideb-installation-are/14325/13 "2017-01-10T23:22:32Z")

</div>

Hi - I did get Dolibarr running on Debian but then other problems convinced me to try Lubunto (16.10) . I got past the first hurdle onlt to run aground on the same problem as Ndrosis with the MySql syntax error.

Anyone with a clue about this?  
Thanks  
MAG

---

<div class="post-metadata">

**Author:** ![Luist](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/l/f1d935/32.png) [@Luist](https://www.dolibarr.org/forum/u/Luist)\
**Post date:** [April 26, 2025, 2:13pm UTC](https://www.dolibarr.org/forum/t/database-passwords-with-dolideb-installation-are/14325/14 "2025-04-26T14:13:45Z")

</div>

I got a solution. Aparently dolideb package doesn’t install a mysql service so I fixed that with mysql-server-8.0. And then I changed the root password to match the empty string of the install.

```auto
sudo apt install mysql-server-8.0
systemctl status mysql
sudo mysql

```

In mysql\>

```auto
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY '';
exit;

```

Then testing it.

```auto
mysql -u root -p

```

After that the installation went well, just asked for the database user to have a password.
