pillar.example

mysql:
  server:
    # root_password: False - to have root@localhost without password
    root_password: 'somepass'
    user: mysql
    # my.cnf sections changes 
    mysqld:
      bind-address: 0.0.0.0
      port: 3307
      log_bin: /var/log/mysql/mysql-bin.log
      binlog_do_db: foo
      auto_increment_increment: 5
      max_connect_errors: 4294967295
    mysql:
      # my.cnf param that not require value
      no-auto-rehash: noarg_present

  # Manage databases
  database:
    - foo
    - bar
  schema:
    foo:
      load: True
      source: salt://mysql/files/foo.schema
    bar:
      load: False

  # Manage users
  # you can get pillar for existent server using import_users.py script
  user:
    - name: frank
      password: 'somepass'
      host: localhost
      databases:
        - database: foo
          grants: ['select', 'insert', 'update']
        - database: bar
          grants: ['all privileges']
    - name: bob
      password_hash: '*6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4'
      host: localhost
      databases:
        - database: foo
          grants: ['all privileges']
          grant_option: True
        - database: bar
          table: foobar
          grants: ['select', 'insert', 'update', 'delete']
    - name: nopassuser
      password: ~
      host: localhost
      databases: []

  # Override any names defined in map.jinja
  lookup:
    server: mysql-server
    client: mysql-client
    service: mysql-service
    config: /etc/mysql/my.cnf
    python: python-mysqldb