Ansible mysql_user multiple priv

Multiple privileges can be specified by separating each one using a forward slash: db.table1:priv/db.table2:priv.

https://docs.ansible.com/ansible/latest/collections/community/mysql/mysql_user_module.html

複数権限は / で区切る or 辞書型

- name: Create user with password, all database privileges and 'WITH GRANT OPTION' in db1 and db2
  community.mysql.mysql_user:
    state: present
    name: bob
    password: 12345dd
    priv: 'db1.*:ALL,GRANT/db2.*:ALL,GRANT'

- name: Create user with password, all database privileges and 'WITH GRANT OPTION' in db1 and db2
  community.mysql.mysql_user:
    state: present
    name: bob
    password: 12345dd
    priv:
      'db1.*': 'ALL,GRANT'
      'db2.*': 'ALL,GRANT'

登録されてるホストとユーザー名の確認

select user, host from mysql.user;

特定のユーザーの権限確認

show grants for 'ユーザー名'@'ホスト名'