New Zabbix installation problem with mysql

[ALav80]

Hello,

I saw this problem a lot in forums, but still cannot solve it for some reason. I have a fresh install on Centos 9, I can connect to mysql with zabbix user:

mysql -uzabbix -ppassword zabbix

Created all tables and everything needed,

This is my /etc/zabbix/zabbix_server.conf:
DBName=zabbix
DBUser=zabbix
DBPassword=password

But when I start Zabbix, I see this in logs:

67807:20221031:140124.467 using configuration file: /etc/zabbix/zabbix_server.conf
31487:20221031:140132.619 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO)
31487:20221031:140132.619 database is down: reconnecting in 10 seconds


What am I missing?

thank you in advance.

[netai]

Hi, I think the problem is related to authorizing remote connections.

Login into mysql console and run this code (be awere to check the correct syntax):

GRANT ALL PRIVILEGES ON *.* TO 'zabbix'@'%' IDENTIFIED BY 'zabbix' WITH GRANT OPTION;
FLUSH PRIVILEGES;