MySQL monitoring, Zabbix, agentd, agent1

CREATE USER 'zbx_monitor'@'%' IDENTIFIED BY 'MvhC40sEi3lHn1ycT5K8';
GRANT REPLICATION CLIENT,PROCESS,SHOW DATABASES,SHOW VIEW ON *.* TO 'zbx_monitor'@'%';
flush privileges;
odbc mon:
CREATE USER 'odbc_monitor'@'%' IDENTIFIED BY 'MLMrbGwqX3kTdxtdPRjN';
GRANT SELECT,REPLICATION CLIENT,PROCESS,SHOW DATABASES,SHOW VIEW ON *.* TO 'odbc_monitor'@'%';
flush privileges;
if agent runs under user 'zabbix':
mkdir -p /var/lib/zabbix

cat << 'EOF' > /var/lib/zabbix/.my.cnf
[client]
user='zbx_monitor'
password='MvhC40sEi3lHn1ycT5K8'
EOF

chown zabbix. -R /var/lib/zabbix

No comments: