[BUG] Creating root user with mysql_user module

[santi-eidu]

Description

According to module documentation, we need to set root password via password-less setup with socket.

Steps to Reproduce

Ansible 2.9
Run molecule test.

Expected behavior:
No error, test finish successfully

Actual behavior:
Error:

Unable to connect to database, check login_user and login_password are correct or /root/.my.cnf has the credentials. Exception message: (1698, u\"Access denied for user 'root'@'localhost'\")"}

Reproduces how often:
[What percentage of the time does it reproduce?]

Environment

• The release version/s you are using: 4.5
• OS: Debian
• Ansible Version: 2.9
• Python Version: 2.7

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.