connection to database 'zabbix' failed

[mizogomo]

I have a problem

Zabbix server is not running: the information displayed may not be current

my server log is:

[Z3001] connection to database 'zabbix' failed: [2003] Can't connect to MySQL server on '192.168.10.5:3306' (111)
3020:20230112:071840.926 database is down: reconnecting in 10 seconds

plz help me

[fvilarnovo]

assuming that you have the DB on a separate server, with mysql-client from the zabbix server node and the zabbix credentials, are you able to connect?

[fvilarnovo]

assuming that you have the DB on a separate server, with mysql-client from the zabbix server node and the zabbix credentials, are you able to connect?

[mizogomo]

assuming that you have the DB on a separate server, with mysql-client from the zabbix server node and the zabbix credentials, are you able to connect?

sql is on the zabbix server

[fvilarnovo]

Ok, then next thing that I would do, is change the ip of the server (in zabbix_server.conf), as there is no need to point to the interface's ip. You should be able to connect to localhost. Also, the same logic as before applys, are you able to connect without zabbix to the DB?

for example:

mysql -h HOST -P PORT_NUMBER -u ZBX_USERNAME -p ZABBIX-DATABASENAME.

Also another thing to check could be the listening address from mysql

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
search for:
bind-address =

Hope it helps!