{"action":"created","issue":{"url":"https://api.github.com/repos/geerlingguy/ansible-role-mysql/issues/121","repository_url":"https://api.github.com/repos/geerlingguy/ansible-role-mysql","labels_url":"https://api.github.com/repos/geerlingguy/ansible-role-mysql/issues/121/labels{/name}","comments_url":"https://api.github.com/repos/geerlingguy/ansible-role-mysql/issues/121/comments","events_url":"https://api.github.com/repos/geerlingguy/ansible-role-mysql/issues/121/events","html_url":"https://github.com/geerlingguy/ansible-role-mysql/issues/121","id":153533765,"number":121,"title":"Error 1045 -- No interruptions and running as root user","user":{"login":"al3x-edge","id":62131,"avatar_url":"https://avatars.githubusercontent.com/u/62131?v=3","gravatar_id":"","url":"https://api.github.com/users/al3x-edge","html_url":"https://github.com/al3x-edge","followers_url":"https://api.github.com/users/al3x-edge/followers","following_url":"https://api.github.com/users/al3x-edge/following{/other_user}","gists_url":"https://api.github.com/users/al3x-edge/gists{/gist_id}","starred_url":"https://api.github.com/users/al3x-edge/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/al3x-edge/subscriptions","organizations_url":"https://api.github.com/users/al3x-edge/orgs","repos_url":"https://api.github.com/users/al3x-edge/repos","events_url":"https://api.github.com/users/al3x-edge/events{/privacy}","received_events_url":"https://api.github.com/users/al3x-edge/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-05-06T20:39:36Z","updated_at":"2016-05-07T03:12:05Z","closed_at":null,"body":"Getting the error 1045 while just trying to run the role on as VPS on Vultr.  The playbook is being run for the first time and without interruptions until this point.  The role is being run as a root user.  `mysql_root_password` is being set and `mysql_root_password_update` is set to `yes`.  The `.my.cnf` file is being created in the user directory correctly.\r\n\r\n```\r\nERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)\r\n```\r\n\r\nInitially thought this was an issue with Ubuntu 16.04 (was testing), but seems to simply be from the switch to this role instead of another one.  "},"comment":{"url":"https://api.github.com/repos/geerlingguy/ansible-role-mysql/issues/comments/217602100","html_url":"https://github.com/geerlingguy/ansible-role-mysql/issues/121#issuecomment-217602100","issue_url":"https://api.github.com/repos/geerlingguy/ansible-role-mysql/issues/121","id":217602100,"user":{"login":"geerlingguy","id":481677,"avatar_url":"https://avatars.githubusercontent.com/u/481677?v=3","gravatar_id":"","url":"https://api.github.com/users/geerlingguy","html_url":"https://github.com/geerlingguy","followers_url":"https://api.github.com/users/geerlingguy/followers","following_url":"https://api.github.com/users/geerlingguy/following{/other_user}","gists_url":"https://api.github.com/users/geerlingguy/gists{/gist_id}","starred_url":"https://api.github.com/users/geerlingguy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/geerlingguy/subscriptions","organizations_url":"https://api.github.com/users/geerlingguy/orgs","repos_url":"https://api.github.com/users/geerlingguy/repos","events_url":"https://api.github.com/users/geerlingguy/events{/privacy}","received_events_url":"https://api.github.com/users/geerlingguy/received_events","type":"User","site_admin":false},"created_at":"2016-05-07T03:12:05Z","updated_at":"2016-05-07T03:12:05Z","body":"@al3x-edge - This role assumes you used the role to set up the VM/server in the first place; if not, then the task that tries to update the password (or perform any other operation in preparation) will fail because the proper password isn't stored inside `{{ mysql_user_home }}/.my.cnf`.\r\n\r\nIf you're switching to this role from another, you'll need to manually create that file with the root password in it first."}}