Hi All,
I am attempting to use Ansible to create a MySQL backup user. It should
be able to read and lock tables for everything. The step in the playbook
is this.
- name: create user - GRANT SELECT, PROCESS, LOCK TABLES ON *.* TO
`backup`@`localhost`
community.mysql.mysql_user:
user: backup
host: localhost
login_password: <redacted>
priv: '*.*:SELECT, PROCESS, LOCK TABLES'
The error message is:
fatal: [ubuntu2004.hcs]: FAILED! => {"changed": false, "msg": "invalid
privileges string: Invalid privileges specified: frozenset({' PROCESS,
LOCK TABLES'})"}
I can see nothing wrong with the priv line. Can someone spot it?
Regards
Ian
--
Ian Hobson
Tel (+66) 626 544 695
--
You received this message because you are subscribed to the Google Groups "Ansible
Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/16f33419-6d92-4097-a0ea-aa52532e29e8%40gmail.com.
