MYSQL Remote DB connect fail

[vitzeg]

Hi, im configuring a new instance of zabbix 3.4 but i cant connect to a remote DB ( i dont want to use locally because zabbix will have a lots of data ) but whenever i configure the hostDB to my cluster IP it fails and wont start i tried to change the conf file and the php conf file too but has not success , when i open on the browser i get the following error
" Database error

• Error connecting to database: Access denied for user 'zabbix'@'localhost' (using password: YES)

even if i put the IP of my cluster the error doesn't change keep saying LOCALHOST , any advice?

regards

[aigars.kadikis]

Hi, vitzeg!

In zabbix database preparation process you executed commands like:

create database zabbix character set utf8 collate utf8_bin;
grant all privileges on zabbix.* to 'zabbix'@'localhost' identified by "password";

Did you also included appropriate rule to allow connections from different hosts like:

grant all privileges on zabbix.* to 'zabbix'@'10.0.2.16' identified by "password";

All existing rules can be listed with:

mysql -uzabbix -p
show grants;

Regards,