{"action":"closed","issue":{"url":"https://api.github.com/repos/geerlingguy/ansible-role-mysql/issues/48","labels_url":"https://api.github.com/repos/geerlingguy/ansible-role-mysql/issues/48/labels{/name}","comments_url":"https://api.github.com/repos/geerlingguy/ansible-role-mysql/issues/48/comments","events_url":"https://api.github.com/repos/geerlingguy/ansible-role-mysql/issues/48/events","html_url":"https://github.com/geerlingguy/ansible-role-mysql/issues/48","id":101991389,"number":48,"title":"Access denied for user 'root'@'localhost' after password change","user":{"login":"ryall","id":161332,"avatar_url":"https://avatars.githubusercontent.com/u/161332?v=3","gravatar_id":"","url":"https://api.github.com/users/ryall","html_url":"https://github.com/ryall","followers_url":"https://api.github.com/users/ryall/followers","following_url":"https://api.github.com/users/ryall/following{/other_user}","gists_url":"https://api.github.com/users/ryall/gists{/gist_id}","starred_url":"https://api.github.com/users/ryall/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ryall/subscriptions","organizations_url":"https://api.github.com/users/ryall/orgs","repos_url":"https://api.github.com/users/ryall/repos","events_url":"https://api.github.com/users/ryall/events{/privacy}","received_events_url":"https://api.github.com/users/ryall/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-08-19T20:30:10Z","updated_at":"2015-08-19T23:07:46Z","closed_at":"2015-08-19T23:07:46Z","body":"Getting this since I updated my MySQL root password in the config.\r\n\r\n```\r\nfailed: [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\": []}\r\nstderr: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)\r\n```\r\n\r\nI 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.\r\n\r\nI am running Ansible 1.9.2 and the server is Ubuntu 14.04.3.\r\n"}}