Access denied for user 'root'@'localhost' after password change

[ryall]

Getting this since I updated my MySQL root password in the config.

failed: [elm] => {"changed": false, "cmd": ["mysql", "-NBe", "SELECT Host FROM mysql.user WHERE User = \"root\" ORDER BY (Host=\"localhost\") ASC"], "delta": "0:00:00.017469", "end": "2015-08-19 22:23:51.071333", "rc": 1, "start": "2015-08-19 22:23:51.053864", "stdout_lines": [], "warnings": []}
stderr: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I have tried manually updating the passwords in the user database (all root/host combinations) and while I can log in fine with the new password over SSH, the role still fails.

I am running Ansible 1.9.2 and the server is Ubuntu 14.04.3.

[ryall]

Seems my root user's .my.cnf on user wasn't updated with the new password. I see in the tasks this happens post DB-update so it's possible something just went wrong the first time.