docker安装mysqld_exproter

exporter:123456

# 创建账户
create user 'exporter'@'%' identified by '123456' with MAX_USER_CONNECTIONS 3 ;

# 设置权限
grant process,replication client,select on *.* to 'exporter'@'%';

# 设置权限2，有的设置 select on *.* 有的设置 SELECT ON performance_schema.*
GRANT PROCESS, REPLICATION CLIENT ON *.* TO 'exporter'@'localhost';
GRANT SELECT ON performance_schema.* TO 'exporter'@'localhost';



docker run -d -p 9104:9104 --name mysqld_exporter \
 prom/mysqld-exporter --mysqld.username="exporter:123456" --mysqld.address="192.168.1.98:3306"

# 这个没有用，会报错
docker run -d -p 9104:9104  -e DATA_SOURCE_NAME="exporter:123456@(192.168.1.98:3306)/" --name mysqld_exporter prom/mysqld-exporter


# 配置到prometheus，并重载配置

  - job_name: "loacl-mysql"
    static_configs:
      - targets: ['192.168.126.130:9104']
        labels:
          instance: "loacl-mysql"

# grafana 面板导入 7362  或者自行搜索导入