Ansible MySQL database setup

gistfile1.txt

# config

/etc/ansible/host_vars/dbserver
---
dbs_inst: ['testdb1', 'testdb2']
dbs:
 - { name: 'testdb1', password: 'password1', priv: 'testdb1.*:ALL' }
 - { name: 'testdb2', password: 'password2', priv: 'testdb2.*:SELECT' }

/etc/ansible/roles/mysql/tasks/main.yml
...
    - name: create additional MySQL databases
      action: mysql_db db={{ item.name }} state=present
      with_items: dbs
      tags:
      - config
      - mysql

    - name: create additional MySQL users
      action: mysql_user name={{ item.name }} password={{ item.password }} priv={{ item.priv }} state=present
      with_items: dbs
      tags:
      - config
      - mysql