Zabbix Mysql Database on Localhost

[TheKyoshi]

Hello

We just installed zabbix on aws ec2 and have the same mysql database on it. The problem is it is not getting any data.
Please let me know if I need to post logs or configurations here

We followed the steps located here

https://sbcode.net/zabbix/setup_mysql_database_monitoring/

Zabbix v6
Zabbix v6 agent
Ubuntu 20

We double checked the /var/lib/zabbix/.my.cnf/
has the correct username and password for database, are able to login to mysql via command line
permissions granted

nothing is touched here, everything is default when we setup zabbix
nano /etc/zabbix/zabbix_server.conf

in
/etc/zabbix/zabbix_agentd.conf
made sure host is matched with the host in the zabbix portal
Include=/etc/zabbix/zabbix_agentd.d/*.conf


in
/etc/zabbix/zabbix_agentd.d/
template_db_mysql.conf

See attached

Thank you

[vladimir_lv]

Do you use SELiunux?

[TheKyoshi]

what is very wierd and we fix it is we made a new
/etc/zabbix/zabbix_agentd.d/
template_db_mysql.conf

it looked like it got corrupted.

now it is pulling data.

Hope this helps someone
thank you