"Get list of hosts for the root user" failed

[ValentinKruegl]

we are using ubuntu-minimal on:
ubuntu 22.04
php reverted to 7.4.
mariadb 10.6.12

TASK [mariadb : Get list of hosts for the root user]

fatal: [db1]: FAILED! => {"changed": false, "cmd": ["/usr/bin/mysql", "-NBe", "SELECT Host FROM mysql.user WHERE User = 'root' ORDER BY (Host='localhost') ASC"], "delta": "0:00:00.012417", "end": "2023-02-28 15:25:21.588737", "msg": "non-zero return code", "rc": 1, "start": "2023-02-28 15:25:21.576320", "stderr": "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)", "stderr_lines": ["ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)"], "stdout": "", "stdout_lines": []}

We worked around it by setting the root password for mariadb to empty.