Using the Ansible community.mysql modules
The new modules:
- https://galaxy.ansible.com/community/mysql
- https://docs.ansible.com/ansible/latest/collections/community/mysql/index.html
Can be installed like this:
ansible-galaxy collection install community.mysql
However they don't appear to actually work using password authentication, see:
So the tasks referenced in #4 (closed) to change between socket and password authentication need to also work using shell / command modules...