The ultimate goal is to have the latest Zabbix release running in container, monitoring a bunch of switches.
Zabbix wants some flavor of MySQL (or postgres) so I figured I would set use the official (Oracle) MySQL 8.0.19 MySQL FOSS image.
I have a running MySQL container but I accidentally set up my zabbix db user to only have local connection privileges.
mysql> SELECT user,host FROM mysql.user;
+------------------+-----------+
| user | host |
+------------------+-----------+
| root | % |
| mysql.infoschema | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
| zabbix | localhost |
+------------------+-----------+
6 rows in set (0.00 sec)
I can't seem to alter this user so it can connect from the other containers in the group, zabbix-server-mysql and zabbix-web-apache-mysql.
Perhaps there's some way of launching a new container so that database 'zabbix' is available to user zabbix over the network.
And I don't understand docker well enough to know if I actually need to have the containers talking to each other over the network or is there some magical docker funtionality whereby they can communicate without IP networking.
Please advise.