Found the problem.
The comma separated list of privileges, cannot have spaces after the commas.
This is unusually user-hostile!
Regards
Ian
This was fixed two years ago
https://github.com/ansible-collections/community.mysql/blob/main/plugins/module_utils/user.py#L522
See also:
https://github.com/ansible-collections/community.mysql/pull/189
https://github.com/ansible-collections/community.mysql/pull/243
This raises a good observation. It is easy to keep ansible updated. It is not so evident how one can keep their collections updated.
How do others keep their collections current?
Walter
We tend to use the ansible version as the starting point, and use just the collection versions from that…
Or do you mean something else?
Dick
If you install a collection via ansible-galaxy how do you keep it updated? Is there a galaxy command to refresh all your existing collections and plugins?
Walter
I don’t know but I also don’t immediately see a good use case for that. We’ve settled on pip installing ansible-core, plus a curated subset of the collections, with the versions that come with ansible. We don’t upgrade collections, just bump to another ansible version (and hence ansible-core and whatever version of collections that comes with).
If you just want to have the latest versions of collections, then I don’t know how to do that, but I haven’t looked into that either.
Dick