MySQL Exporter Quickstart and Dashboard

config.my-cnf

[client]
user=username
password=password

docker-compose.yml

services:
  mysqld-exporter:
    image: prom/mysqld-exporter:latest
    container_name: mysqld-exporter
    environment:
      - MYSQLD_EXPORTER_PASSWORD=password
      - DATA_SOURCE_NAME="user:password@(db:3306)/database"
    command:
      - --mysqld.address=database:3306
      - --mysqld.username=username
      - --web.config.file=/cfg/webconfig.yml
#       - --config.my-cnf=/cfg/.my.cnf
    volumes:
      - ./webconfig.yml:/cfg/webconfig.yml
#       - ./config.my-cnf:/cfg/.my.cnf
    ports:
      - 9104:9104
    links:
      - db
    depends_on:
      - db

# https://grafana.com/grafana/dashboards/14057-mysql/

webconfig.yml

# echo 1234 | htpasswd -inBC 10 "" | tr -d ':\n'
basic_auth_users:
  admin: $2y$10$DflJBSLBlS2z3d9rk6pdk.EadVxBVlXc084wPgCqoaW2T1KblOjyi