Database connection

[Goldengate]

Hi fellow Zabbix admins!

I have installed Zabbix in one HP server with Debian 8 "Jessie" with the repo files, the IP address is 192.168.1.6 but all my MySQL databases are in other server IP address 192.168.1.10. So I edit /etc/zabbix/zabbix_server.conf with:

DBHost=192.168.1.10

And in the file /etc/zabbix.conf.php

$DB['TYPE'] = 'MYSQL';
$DB['SERVER'] = '192.168.1.10';
$DB['PORT'] = '0';
$DB['DATABASE'] = 'zabbix';

Now in my zabbix-server logs I get this:

[Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'192.168.1.6' (using password: YES).
Database is down. Reconnecting in 10 seconds.

I don't know if I'm missing something, this is very very weird.

Any suggestions or ideas are welcome!

Best regards!


Frank

[Atsushi]

You must grant permission to zabbix user on your MySQL.
I think you grant to zabbix user on localhost only.
If you want access from remote host, you must create remote user and grant access.

ex.

mysql> grant all privileges on zabbix.* to 'zabbix'@'192.168.1.6' identified by 'password' ;