Zabbix MySQL monitoring help

[mslavin21]

Hello,
I am having quite a bit of difficult configuring zabbix monitoring of a MySQL server. I've configured the zabbix_agentd.conf with an Include=/opt/conf/zabbix_agentd/. I've also created a new zabbix MySQL account and granted it the following permissions:

GRANT ALL PRIVILEGES ON *.* TO 'zabbix'@'localhost'; IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'zabbix'@'127.0.0.1'; IDENTIFIED BY 'password';

I've also configured a new directory /var/lib/zabbix and have configured a .my.cnf file with the following:
[client]
user=zabbix
password=password

However, when I start zabbix I see the following errors;
access denied for user 'root'@'localhost' (using password: NO)

Does anyone know what could possibly be wrong?

[pc99096]

check my settings:

/usr/local/etc/.my.cnf

[mysql]
user=zabbix
password=123456
[mysqladmin]
user=zabbix
password=123456

zabbix_agentd.conf

UserParameter=mysql.status[*],echo "show global status where Variable_name='$1';" | HOME=/usr/local/etc/ mysql -N | awk '{print $$2}'
UserParameter=mysql.ping,HOME=/usr/local/etc/ mysqladmin ping | grep -c alive

[tchjts1]

This post may help. https://www.zabbix.com/forum/showthread.php?t=41659