install mysql exporter
wget https://github.com/prometheus/mysqld_exporter/releases/download/v${VER}/mysqld_exporter-${VER}.linux-amd64.tar.gztar -xf mysqld_exporter-0.15.0-rc.0.linux-amd64.tar.gzmv mysqld_exporter-0.15.0-rc.0.linux-amd64 [root@vm1 ~]# cat /usr/local/mysqld_exporter/mysql.cnf [client]user=readpassword=m!maport=6333
add service
[root@vm1 home]# vim /usr/lib/systemd/system/mysqld_exporter.service[Unit]Description=mysqld_exporterDocumentation=https://prometheus.ioWants=network-online.targetAfter=network.target[Service]Type=simpleUser=rootExecStart=/usr/local/mysqld_exporter/mysqld_exporter --config.my-cnf=/usr/local/mysqld_exporter/mysql.cnf --web.listen-address=0.0.0.0:39104Restart=on-failure[Install]WantedBy=multi-user.target[root@vm1 home]# systemctl daemon-reload[root@vm1 home]# systemctl restart mysqld_exporter[root@vm1 home]# systemctl enable mysqld_exporterCreated symlink from /etc/systemd/system/multi-user.target.wants/mysqld_exporter.service to /usr/lib/systemd/system/mysqld_exporter.service.[root@vm1 home]# netstat -tnlpActive Internet connections (only servers)Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 1399/master tcp6 0 0 :::39104 :::* LISTEN 4456/mysqld_exporte