Configuring zabbix template and mysql access for monitoring mysql

mysql -uroot -p<mysql root password> -e"GRANT USAGE ON *.* TO 'zabbix'@'127.0.0.1' IDENTIFIED BY '123456'";
mysql -uroot -p<mysql root password> -e"GRANT USAGE ON *.* TO 'zabbix'@'localhost' IDENTIFIED BY '123456'";
mysql -uroot -p<mysql root password> -e"flush privileges"
mysql -uzabbix -p123456 -e"status"

Les connexions en cours :

netstat -anp |grep 'tcp|udp' | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort -n
ss | awk '{print $5}' | cut -d: -f4 | sort | uniq -c | sort -n

monitoring pour linux