迁移Centreon至新服务器及新版本时MariaDB出现'centreon'@'localhost'访问拒绝错误的解决求助

各位前辈好，我目前正在将Centreon迁移到新服务器并升级至新版本，但是在Debian 11的syslog中一直出现以下访问拒绝错误：

mariadbd[1640]: 2023-10-20 11:13:52 13360 [Warning] Access denied for user 'centreon'@'localhost' (using password: YES)

我已经尝试过检查并授予权限，执行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)

但现在还是会持续出现这个访问拒绝的警告，有没有大佬能指点一下该怎么解决这个问题？

备注：内容来源于stack exchange，提问作者RAN55