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 'ユーザー名'@'ホスト名'