Request update to priv section of mysql_user task to denote the absence of spacing.

[rujschafer]

SUMMARY

We just resolved a problem with a role where the priv: section of the mysql_user task was idempotent if running in normal mode but not idempotent if running in check mode. It was all based on a space in the priv section.

This code yielded idempotent in normal mode and not idempotent in check mode.

community.mysql.mysql_user:
    name: "{{ mysql_backup_user.user }}"
    password: "{{ mysql_backup_user.pass }}"
    priv: '*.*: ALL'
    host: "{{ item }}"
    state: present
    login_user: root
    login_password: "{{ mysql_root_password }}"
  with_items: "{{ mysql_backup_hosts }}"

this code yielded idempotent for both normal and check mode.

community.mysql.mysql_user:
    name: "{{ mysql_backup_user.user }}"
    password: "{{ mysql_backup_user.pass }}"
    priv: '*.*:ALL'
    host: "{{ item }}"
    state: present
    login_user: root
    login_password: "{{ mysql_root_password }}"
  with_items: "{{ mysql_backup_hosts }}"

ISSUE TYPE

• Documentation Report

For other readers help, please add wording in the priv section to denote removal of any extra spacing in the string.

COMPONENT NAME

community.mysql.mysql_user

ANSIBLE VERSION

ansible [core 2.15.8]
  config file = $HOME/ansible.cfg
  configured module search path = ['$HOME/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules']
  ansible python module location = /usr/local/lib/python3.11/site-packages/ansible
  ansible collection location = $HOME/collections
  executable location = /usr/local/bin/ansible
  python version = 3.11.2 (main, Sep 12 2023, 00:00:00) [GCC 11.3.1 20221121 (Red Hat 11.3.1-4)] (/usr/bin/python3.11)
  jinja version = 3.1.2
  libyaml = True