@Guillaume 

Can you confirm that you have:

• l ] created a user with root privileges
  • https://docs.centreon.com/docs/21.10/installation/installation-of-a-central-server/using-packages/#with-a-remote-database
• > ] using the credentials from that user
  • you can test from your central to the db with
    • mariadb -h IP-for-DB -u yourUser -p

Hello Ponchoh;

Thanks for you answer.

Yes all prerequisites are OK.

On my DB server before the web installation part:

SELECT User, Host FROM mysql.user WHERE Host = 'IP_CENTRAL';
+------+--------------+
| User | Host         |
+------+--------------+
| root | IP_CENTRAL   |
+------+--------------+
1 row in set (0.001 sec)

And

SHOW GRANTS FOR 'root'@'IP_CENTRAL';
+--------------------------------------------------------------------------------------------------------------------------+
| Grants for root@IP_CENTRAL                                                                                               |
+--------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO `root`@`IP_CENTRAL` IDENTIFIED VIA mysql_native_password USING '*PASSWORD' OR unix_socket |
+--------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)

Same commands from the WEB server with mysql root user just created:

mysql -u root -pcentreon -h IP_BDD_SERVER
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 14
Server version: 10.5.16-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB  (none)]> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB  mysql]> SELECT User, Host FROM mysql.user WHERE Host = 'IP_CENTRAL';
+------+------------+
| User | Host       |
+------+------------+
| root | IP_CENTRAL |
+------+------------+
1 row in set (0.001 sec)

MariaDB  mysql]> SHOW GRANTS FOR 'root'@'IP_CENTRAL';
+--------------------------------------------------------------------------------------------------------------------------+
| Grants for root@IP_CENTRAL                                                                                               |
+--------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO `root`@`IP_CENTRAL` IDENTIFIED VIA mysql_native_password USING '*PASSWORD' OR unix_socket |
+--------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)

MariaDB  mysql]> CREATE DATABASE toto;
Query OK, 1 row affected (0.001 sec)

MariaDB  mysql]> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| toto               |
+--------------------+
4 rows in set (0.000 sec)

MariaDB  mysql]>

Now, I launch the web installation in my browser.
All paths are the default paths. No change in the 5 first steps.

Step 6:

And at Step 7:

Always from the web server:

MariaDB amysql]> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| centreon           |
| centreon_storage   |
| information_schema |
| mysql              |
| performance_schema |
| toto               |
+--------------------+
6 rows in set (0.001 sec)

The 2 databases have been created.

And tables too:

MariaDB amysql]> use centreon
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB acentreon]> SHOW TABLES;
+-----------------------------------------+
| Tables_in_centreon                      |
+-----------------------------------------+
| ...                                     |
+-----------------------------------------+
164 rows in set (0.001 sec)

MariaDB acentreon]>

I don’t understand why process hangs at this steps because rigths and grants seems to be correct ?

This might be it:

In fact, it was really the BDD server IP address.
Bad screenshot modification to hide the IP_BDD...

CREATE USER '<USER>'@'<IP>' IDENTIFIED BY '<PASSWORD>';
GRANT ALL PRIVILEGES ON *.* TO '<USER>'@'<IP>' WITH GRANT OPTION;
FLUSH PRIVILEGES;

missing the “ WITH GRANT OPTION “ ?

SELECT User,Host,Grant_priv FROM mysql.user;

Hi Ponchoh,

Yes, “ WITH GRANT OPTION “ was missing…

A bad copy/paste from the official documentation

Thanks for your sharp look… I don't know how soon I will realize this