{"action":"opened","issue":{"url":"https://api.github.com/repos/geerlingguy/ansible-role-mysql/issues/34","labels_url":"https://api.github.com/repos/geerlingguy/ansible-role-mysql/issues/34/labels{/name}","comments_url":"https://api.github.com/repos/geerlingguy/ansible-role-mysql/issues/34/comments","events_url":"https://api.github.com/repos/geerlingguy/ansible-role-mysql/issues/34/events","html_url":"https://github.com/geerlingguy/ansible-role-mysql/issues/34","id":71186993,"number":34,"title":"Clearify running by root requirement in documentation","user":{"login":"chuwy","id":681171,"avatar_url":"https://avatars.githubusercontent.com/u/681171?v=3","gravatar_id":"","url":"https://api.github.com/users/chuwy","html_url":"https://github.com/chuwy","followers_url":"https://api.github.com/users/chuwy/followers","following_url":"https://api.github.com/users/chuwy/following{/other_user}","gists_url":"https://api.github.com/users/chuwy/gists{/gist_id}","starred_url":"https://api.github.com/users/chuwy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chuwy/subscriptions","organizations_url":"https://api.github.com/users/chuwy/orgs","repos_url":"https://api.github.com/users/chuwy/repos","events_url":"https://api.github.com/users/chuwy/events{/privacy}","received_events_url":"https://api.github.com/users/chuwy/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-04-27T05:53:40Z","updated_at":"2015-04-27T05:53:40Z","closed_at":null,"body":"I've tried to run this role on my vagrant with following configuration:\r\n```\r\n- hosts: all\r\n  remote_user: vagrant\r\n  sudo: yes\r\n  vars:\r\n    mysql_user_home: /home/vagrant\r\n    mysql_root_password: root\r\n    mysql_databases:\r\n      - name: sgt\r\n    mysql_users:\r\n      - name: sgt\r\n        host: localhost\r\n        password: verysecure\r\n        priv: \"sgt.*:ALL\"\r\n```\r\n\r\nAnd ended up with following error:\r\n```\r\nTASK: [geerlingguy.mysql | Get list of hosts for the anonymous user.] *********\r\nfailed: [default] => {\"changed\": false, \"cmd\": [\"mysql\", \"-NBe\", \"SELECT Host FROM mysql.user WHERE User = \\\"\\\"\"], \"delta\": \"0:00:00.006077\", \"end\": \"2015-04-27 05:46:49.456704\", \"rc\": 1, \"start\": \"2015-04-27 05:46:49.450627\", \"stdout_lines\": []}\r\nstderr: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)\r\n````\r\nI've spent a LOT of time trying to figure out why this happening and it appears I have to run role as root. I think it should be clear from documentation. Or may be I've done something wrong?"}}