How to split the DB from the Zabbix server?

[tchjts1]

I want to test putting the MySql database on a separate server, but am having some minor issues.

I had the DB on the same server with Zabbix and am now trying to point it to another server. The steps I have done so far is this:

1 - copied the existing database to the new server
2 - In zabbix_server.conf: changed DBHost value to the IP of the new MySql server
3 - In zabbix.conf.php, changed the $DB["SERVER"] value to the IP of the new MySql server

Restarted MySql
Restarted Zabbix server

Receiving this error: Lost connection to MySQL server at 'reading initial communication packet', system error: 111[/home/zabbix/public_html/include/db.inc.php:54]

Hopefully I am missing something simple here. Any help is appreciated.

[tchjts1]

Ok... I think it has to do with my.cnf. I commented out the bind-address variable and am now receiving a different error:

Host '<my IP address>' is not allowed to connect to this MySQL server[/home/zabbix/public_html/include/db.inc.php:54]

Anyone know the setting to modify in my.cnf to allow remote connections? (MySql 5)

[tchjts1]

Found the issue. I had to grant the Zabbix server permission to connect to that DB by using:

mysql> grant all on zabbix.* to zabbix@'<ZabbixServerIP>' identified by 'WhateverPassword';