Forum GLPI-Project

master-pfe

Member

Registered: 2024-04-28

Posts: 13

Can't connect to the database : The server answered: Permission denied

Hello everyone,

I'm currently installing GLPi in my environment Ubuntu 22.04 and I'm having an issue with database permissions. Here are the versions I'm using:
   * GLPi       : 10.0.15
   * MySQL   : 8.0.36
   * Apache  : 2.4.52
   * PHP       : 8.1.2
I have created a user glpi_admin with the following permissions:

mysql> SHOW GRANTS FOR 'glpi_admin'@'localhost';
+----------------------------------------------------------------------------------------------------------------------------------+
| Grants for glpi_admin@localhost                                                                                     |
+----------------------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO `glpi_admin`@`localhost`                                                     |
| GRANT ALL PRIVILEGES ON `glpidb`.* TO `glpi_admin`@`localhost`                         |
| GRANT SELECT ON `mysql`.`time_zone_name` TO `glpi_admin`@`localhost`           |
+----------------------------------------------------------------------------------------------------------------------------------+
3 rows in set (0.00 sec)

However, when I try to connect to the database from GLPi, I receive an error message stating that access is denied. Can someone help me troubleshoot this database permissions issue?

Thank you in advance for your assistance!