gistfile1.txt

mysql-server:
  pkg.installed

mysql:
  service.running:
    - name: mysql
    - require:
      - pkg: mysql-server

python-mysqldb:
  pkg.installed

libmysqlclient-dev:
  pkg.installed

boomer_dev:
  mysql_user.present:
    - name: boomer_user
    - password: testbam1983
    - require:
      - service: mysql
      - pkg: python-mysqldb
  mysql_database.present:
    - name: boomer_dev
    - require:
      - mysql_user.present: boomer_user
  mysql_grants.present:
    - grant: all privileges
    - database: boomer_dev.*
    - user: boomer_user
    - require:
      - mysql_database.present : boomer_dev

boomer_dev:
  mysql_user.present:
    - name: boomer_user
    - password: testbam1983
    - require:
      - service: mysql
      - pkg: python-mysqldb

  mysql_database.present:
    - name: boomer_dev
    - require:
      - mysql_user: boomer_user

  mysql_grants.present:
    - grant: all privileges
    - database: boomer_dev.*
    - user: boomer_user
    - require:
      - mysql_database: boomer_dev