The Ultimate Guide to High Availability with MariaDB

mariadb access denied to centreon@localhost

Hello, Im trying to migrate centreon to a new server and version debia11. I have this error in syslog:

mariadbd[1640]: 2023-10-20 10:20:07 12827 [Warning] Access denied for user 'centreon'@'localhost' (using password: YES)

I have try to grant all privileges

GRANT USAGE ON *.* TO `centreon`@`localhost` IDENTIFIED BY PASSWORD '*xxxxxx'
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, EVENT ON `centreon`.* TO `centreon`@`localh ost`
GRANT ALL PRIVILEGES ON `mysql`.* TO `centreon`@`localhost`
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, EVENT ON `centreon_storage`.* TO `centreon` @`localhost`

But i still have the error.

How can i check what is wrong? or what database is trying to access ?

Thanks,

Answer Answered by RAN 55 in this comment.

We are checking some settings because we think is not a permission problem. Thanks for the answer Daniel.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.