mysql template remote problem

[cirilloblu]

Hi!
I have a problem with the zabbix for set up a remote template mysql.
On the local server vm00, which I want check mysql, I get the info and the setting work:

zabbix_agentd -t mysql.status[Bytes_received]
mysql.status[Bytes_received] [t|1137644711]

but when i try to get info from the zabbix server I get this error:

zabbix_get -s vm00 -k mysql.status[Com_commit]
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)

How can I resolve this? there is different config file for zabbix_get and zabbix_agentd?
THank you!

[Atsushi]

When running zabbix_agentd locally, I think that the setting of the user who executed it was used.
To get the value from zabbix_agentd via the network, the setting of the user who is running zabbix_agentd is used.

Please check whether the authentication information necessary for accessing MySQL is set up.
For example, setting to .my.cnf at zabbix user's home directory.

[cirilloblu]

Ok, I changed the file /etc/my.cnf and it works.
Thank you