ZABBIX NÃO CONECTA NA DATABASE

[yagojohnny]

Olá a todos,
Pessoal estou com um problema... Meu zabbix não conecta na database criada, mesmo com a senha correta e o nome do usuário e database correta também.

Veja o log.

root@monitoramento:~# tail -f /var/log/zabbix/zabbix_agentd.log
1034:20220524:193003.412 **************************
1034:20220524:193003.412 using configuration file: /etc/zabbix/zabbix_agentd.conf
1034:20220524:193003.412 agent #0 started [main process]
1035:20220524:193003.413 agent Home started [collector]
1038:20220524:193003.414 agent #4 started[listener #3]
1039:20220524:193003.414 agent #5 started [active checks #1]
1036:20220524:193003.414 agent Forum started[listener #1]
1037:20220524:193003.415 agent #3 started[listener #2]
1039:20220524:193003.416 Unable to connect to [127.0.0.1]:10051 [cannot connect to [[127.0.0.1]:10051]: [111] Connection refused]
1039:20220524:193003.416 Active check configuration update started to fail
^C
root@monitoramento:~# tail -f /var/log/zabbix/zabbix_server.log
1192:20220524:193004.142 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
1192:20220524:193004.142 database is down: reconnecting in 10 seconds
1192:20220524:193014.145 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
1192:20220524:193014.145 database is down: reconnecting in 10 seconds
1192:20220524:193024.145 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
1192:20220524:193024.145 database is down: reconnecting in 10 seconds
1192:20220524:193034.146 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
1192:20220524:193034.146 database is down: reconnecting in 10 seconds
1192:20220524:193044.147 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
1192:20220524:193044.147 database is down: reconnecting in 10 seconds
1192:20220524:193054.148 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
1192:20220524:193054.148 database is down: reconnecting in 10 seconds
1192:20220524:193104.149 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
1192:20220524:193104.149 database is down: reconnecting in 10 seconds
1192:20220524:193114.149 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
1192:20220524:193114.150 database is down: reconnecting in 10 seconds
1192:20220524:193124.150 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
1192:20220524:193124.150 database is down: reconnecting in 10 seconds
1192:20220524:193134.151 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
1192:20220524:193134.151 database is down: reconnecting in 10 seconds
1192:20220524:193144.152 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
1192:20220524:193144.152 database is down: reconnecting in 10 seconds
1192:20220524:193154.153 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
1192:20220524:193154.153 database is down: reconnecting in 10 seconds

Me ajudem pf.

[mfortes]

Quando você criou o banco, vc deu permissao no usuario zabbix nesse banco?

[joseroa]

Primeiro verifique com o seguinte comando

mysql -u user -p TUpassword

Se não conectar, verifique os logs do mysql.

Qual sistema operacional você está usando?