create user 'exporter'@'%' identified by '123456';
create user 'exporter'@'127.0.0.1' identified by '123456';
create user 'exporter'@'localhost' identified by '123456';
grant process,replication client,select on *.* to 'exporter'@'%' identified by 'admin123';
grant process,replication client,select on *.* to 'exporter'@'127.0.0.1' identified by 'admin123';
grant process,replication client,select on *.* to 'exporter'@'localhost' identified by 'admin123';
flush privileges;
配置mysqld 主从复制的指标暴露器
上传mysqld_exporter-0.12.1.linux-amd64.tar.gz 到/opt
tar -zxvf mysqld_exporter-0.12.1.linux-amd64.tar.gz -C /usr/local
vim /usr/local/mysqld_exporter-0.12.1.linux-amd64/.my.cnf
[client]
user=exp