Configuration database SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'

Hello,

I am installing Centreon 23.10 on Debian 11 by the documentation, using the apt sources.

Web And Post Installation | Centreon Documentation

everything is done as “root” (su -)

I found this topic related to my case:Install Error: SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' | Community (centreon.com)

same issue for me; stuck at step 7 :

• i ran mysql_secure_installation and replied “yes” to all question except “disallow remote login” for which i answered “no” (as mentioned in documentation)
• ps aux | grep mariadb shows me service is running:

root@centreon-server:~# ps aux | grep mariadb
mysql      35339  0.0  1.4 1871152 118340 ?      Ssl  01:53   0:00 /usr/sbin/mariadbd
root       35505  0.0  0.0   8808   704 pts/0    S+   02:00   0:00 grep mariadb

• in mysql, SELECT * FROM mysql.user; 

among users i found the root part:

  | localhost | root        | *2B556678EB31Dxxxxxxxxx3775FA3D03E | Y           | Y           | Y           | Y           | Y           | Y         | Y           | Y             | Y            | Y         | Y          | Y               | Y          | Y          | Y            | Y          | Y                     | Y                | Y            | Y               | Y                | Y                | Y              | Y                   | Y                  | Y                | Y          | Y            | Y                      | Y                   |          |            |             |              |             0 |           0 |               0 |                    0 | 

(i hid some of the password hash with xxx)

which seems to implies i have set up a password for the mysql root password?

i tried adding localhost also in the form.

what did i miss?