---
 - hosts: all
   gather_facts: no
   ignore_errors: yes
   become: yes
   tasks:
   - name: create nova_api database
     mysql_db: name='nova_api' state=present login_user=root login_password=""

   - name: create nova  database
     mysql_db: name=nova state=present login_user=root login_password=""

   - name: grant privileges to user nova on  nova_api user in db.
     mysql_user:
       name: nova
       password: nova
       priv: 'nova_api.*:ALL,GRANT'
       state: present
       login_user: root
       login_password:
       host: "{{ item }}"
     with_items:
     - localhost
     - "%"
     register: endpoint

   - debug: msg="{{ endpoint }}"


   - name: grant privileges to nova user in nova db.
     mysql_user:
       name: nova
       password: nova
       priv: 'nova.*:ALL,GRANT'
       state: present
       login_user: root
       login_password:
       host: "{{ item }}"
     with_items:
     - localhost
     - "%"
     register: endpoint

   - debug: msg="{{ endpoint }}"