- name: add db
mysql_db: name={{ item.user }} state=present
with_items: users
- name: add user
mysql_user: name={{ item.user }} host=localhost password={{ mysql_pass }}
state=present priv={{ item.db }}.*:ALL
with_items: users
---
users:
- user: user1
db:
- db1
- db11
- user: user2
db:
- db2
- user: user3
db:
- db3
- db33
- db333