Changing the MySQL root User from auth_socket to Password Authentication Using Ansible
MySQL 5.7 introduced a change in which at install time, the root user is configured using the `auth_socket` authentication plugin. Unfortunately, the Ansible `mysql_user` module does not support authentication plugins, and will fail if you try to set a password on the root user. We will work around this issue.
Tags: ansible, mysql