{% for user in pillar.mysql.users %}
'{{ user.keys()[0] }}@{{ user.values()[0]['host'] }}':
  mysql_user.present:
    - name: '{{ user.keys()[0] }}'
    - host: '{{ user.values()[0]['host'] }}'
    - password: '{{ user.values()[0]['password'] }}'

{%   for database, grants in user.values()[0]['grants'].iteritems() %}
'{{ user.keys()[0] }}@{{ user.values()[0]['host'] }}::{{ database }}':
  mysql_grants.present:
    - user: '{{ user.keys()[0] }}'
    - host: '{{ user.values()[0]['host'] }}'
    - database: '{{ database }}'
    - grant: {{ grants }}
{%   endfor %}
{% endfor %}


pillar -


mysql:
  root_user:
    passwd: 'fooo'
  databases:
    - std
  users:
    - std:
        host: 'localhost'
        password: 'foooo'
        grants:
          'std.*': select,insert,update,delete