I am trying out the role on Ubuntu 26.04. I am encountering an error when I am using a custom mysql_user_name:
TASK [geerlingguy.mysql : Ensure default user is present.] ****************************************************************************************************
[ERROR]: Task failed: Module failed: unable to connect to database, check login_user and login_password are correct or /root/.my.cnf has the credentials. Exception message: (1698, "Access denied for user 'root'@'localhost'")
Origin: /home/pieter/.ansible/roles/geerlingguy.mysql/tasks/secure-installation.yml:2:3
I am trying out the role on Ubuntu 26.04. I am encountering an error when I am using a custom
mysql_user_name: