
Centreon を新しいサーバーとバージョンに移行しようとしているのですが、debian11 の syslog にこのエラーが表示されます。
mariadbd[1640]: 2023-10-20 11:13:52 13360 [Warning] Access denied for user 'centreon'@'localhost' (using password: YES)
権限を付与しようとしました
hMariaDB [(none)]> SHOW GRANTS FOR 'centreon'@'localhost';
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for centreon@localhost |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO `centreon`@`localhost` IDENTIFIED BY PASSWORD '*xxx' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, EVENT ON `centreon`.* TO `centreon`@`localhost` |
| 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` |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
4 rows in set (0.000 sec)
しかし、まだこのエラーが発生します。どうすれば修正できますか?