On the client, add a zabbix database user (use a unique password)

GRANT USAGE ON *.* TO 'zabbix'@'%' IDENTIFIED BY 'super-secret-password';

Add the following to the end of /etc/zabbix/zabbix_agentd.conf

# MySQL Keys
UserParameter=mysql.status[*],(test -f /usr/bin/mysqladmin && mysqladmin -u$1 -p$2 extended-status 2>/dev/null | awk '/ $3 /{print $$4}')
UserParameter=mysql.ping[*],(test -f /usr/bin/mysqladmin && mysqladmin -u$1 -p$2 ping | grep alive | wc -l)
UserParameter=mysql.version,(test -f /usr/bin/mysqladmin && mysqladmin -V)

If this is also a MySQL slave, add the follwing to the end of /etc/zabbix/zabbix_agentd.conf

# MySQL Slave Keys
UserParameter=mysql.slave[*],mysql -u$1 -p$2 -e "show slave status\G" | awk '/$3:/ {print $NF}' | sed s/Yes/1/ | sed s/No/0/

Restart the Zabbix agent

/etc/init.d/zabbix-agent restart

The key parameters should be mysql-username, mysql-password, and for mysql.status the status Item you want to query. So, for example:


I like to use macros for this to allow for a different username/password combination on each host, so it would be something like