##Create a new company Database,  & create a user with all privileges on that DB
---
- hosts: localhost
  sudo: no
  connection: local
  vars:
    playbook_version: 1.0
    vars_files:
     - db_details.yml
  tasks:
  - name: Create a new database with name xyz
    mysql_db:
      login_host: {{ DB_HOST }}
      login_user: {{ DB_MASTER_USER }}
      login_port: 3306
      login_password: {{ DB_MASTER_PASSWD }}
      name: {{ DB_NAME }}
      state: present
  - name: Create a new user with name {{ DB_USER }}
    mysql_user:
      login_host: {{ DB_HOST }}
      login_user: {{ DB_MASTER_USER }}
      login_port: 3306
      login_password: {{ DB_MASTER_PASSWD }}
      name: {{ DB_USER }}
      password: {{DB_CUSTOMER_PASSWD}}
      host: '%'
      priv: '{{ DB_NAME }}.*:ALL'
      state: present