I have two Ubuntu Servers running 20.04. I am running the Zabbix Server on a Raspberry Pi. I am using version 6.2 of Zabbix. I can collect basic stats from both Ubuntu Servers. I can collect mySQL data from one, but no data appears on the other. Both are running 6.2 agents. I cloned the host files (and and then changed the IP) to ensure they are the same. Both templates, agent config and .my.cnf files are the same.
The really strange thing is the error on the mySQL page is for no access to zabbix@localhost. I believe this is only used by the Zabbix Server not the agents. See screenshot below and error.

Screenshot of server that is working:
The really strange thing is the error on the mySQL page is for no access to zabbix@localhost. I believe this is only used by the Zabbix Server not the agents. See screenshot below and error.
Screenshot of server that is working:
Comment