Hello,

I have exactly the same problem.

Please can someone help us with these issues?

Thank you!

Hello,

Nobody can help us with this issue?

Thanks,

Impossible to change the password...

Hello @Cyrille , just solved it this by doing this:

1. connect to mysql running “mariadb”
2. SELECT contact_id, contact_name FROM centreon.contact; (to get the ID of the contact you want to reset the password)
3. UPDATE contact_password SET password = md5('XXX') WHERE contact_id = XX;
4. Voilà 

Hi,

Not solved for this service...

Hello,

Did you solve the problem for centreon-engine access denied?

I followed the doc to secure my install and I get the same messages.

No user called centreono-engine in MariaDB.

Thank you

Bonjour,

Avez-vous résolu le souci “access denied” pour l’utilisateur centreon-engine?

J’ai le même message après avoir suivi la doc pour sécuriser l’installation, et je n’ai pas d’utilisateur centreon-engine dans MariaDB.

Cela ressemble a un problème strictement système de Linux, mais je n’ai pas trouvé où modifier ça dans l’interface Web de centreon.

Merci

Hi,

I have the same problem : UNKNOWN: Cannot connect: Access denied for user 'centreon-engine'@'localhost'

The database’s user is centreon and not centreon-engine, where can we change this information ?

I’ve tried to add macros in the centreon host configuration MYSQLUSERNAME and MYSQLPASSWORD  but he keep centreon-engine @ localhost.

Thank’s for your help.

Now, im going to help in the forum.

I had the same problem, when you copy the configuration files, you overwrite the file that contain the password:

https://thewatch.centreon.com/platform-7/mariadb-access-denied-for-user-centreonatlocalhost-2439

the passwords are correctly entered in plain text in both files but it still does not work

please have you a solution ?

a solution ?

to get around the problem:

CREATE USER 'centreon-engine'@'localhost' IDENTIFIED BY 'centreon';

GRANT ALL PRIVILEGES ON *.* TO 'centreon-engine'@'localhost' WITH GRANT OPTION;

@Cyrille 

bonjour Cyrille, peux tu lister les users que tu as actuellement au niveau de ta base de données ?

par exemple : select user, host from mysql.user where host <> 'localhost';

essaie aussi : select user, host from mysql.user where host <> 'adress-ip';

Kay

Salut,  la question ne porte que sur une problématique de monitoring: toujours repartir de la doc:

 Monitor a MySQL or MariaDB database | Centreon Documentation

Suit la procédure de création du User sur mariadb indiqué dans la doc

ajoute le champs MYSQLUSERNAME à ton hôte comme décrit dans la doc et le tour est joué.