{"action":"created","issue":{"url":"https://api.github.com/repos/geerlingguy/drupal-vm/issues/1452","repository_url":"https://api.github.com/repos/geerlingguy/drupal-vm","labels_url":"https://api.github.com/repos/geerlingguy/drupal-vm/issues/1452/labels{/name}","comments_url":"https://api.github.com/repos/geerlingguy/drupal-vm/issues/1452/comments","events_url":"https://api.github.com/repos/geerlingguy/drupal-vm/issues/1452/events","html_url":"https://github.com/geerlingguy/drupal-vm/issues/1452","id":238794412,"number":1452,"title":"mysql access possible through cmder but not through adminer","user":{"login":"jestinijames","id":28772215,"avatar_url":"https://avatars0.githubusercontent.com/u/28772215?v=3","gravatar_id":"","url":"https://api.github.com/users/jestinijames","html_url":"https://github.com/jestinijames","followers_url":"https://api.github.com/users/jestinijames/followers","following_url":"https://api.github.com/users/jestinijames/following{/other_user}","gists_url":"https://api.github.com/users/jestinijames/gists{/gist_id}","starred_url":"https://api.github.com/users/jestinijames/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jestinijames/subscriptions","organizations_url":"https://api.github.com/users/jestinijames/orgs","repos_url":"https://api.github.com/users/jestinijames/repos","events_url":"https://api.github.com/users/jestinijames/events{/privacy}","received_events_url":"https://api.github.com/users/jestinijames/received_events","type":"User","site_admin":false},"labels":[{"id":77016988,"url":"https://api.github.com/repos/geerlingguy/drupal-vm/labels/question","name":"question","color":"cc317c","default":true},{"id":193170879,"url":"https://api.github.com/repos/geerlingguy/drupal-vm/labels/windows","name":"windows","color":"0052cc","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2017-06-27T09:45:46Z","updated_at":"2017-06-28T07:56:38Z","closed_at":null,"body":"\r\n### Issue Type\r\n - Bug Report / Support Request\r\n\r\n\r\n### Your Environment\r\n```\r\nvirtual box 5.1.22r115126\r\nVagrant 1.9.5\r\nansible 2.3.1.0\r\n```\r\n\r\n### Your OS\r\nWindows 10 Enterprise Edition\r\n\r\n\r\n\r\n### Summary\r\n\r\nSo one of the problems I have been having for the longest time is that I can't login to my server through adminer. Since this is a default setup I haven't changed anything. \r\n\r\nSystem: mySQL\t\r\nServer: local8\r\nUsername: root\t\r\nPassword: root\t\r\n\r\nResult: Access denied for user 'root'@'localhost' (using password: NO)\r\n\r\nThere are two ways I can access the server through command line:\r\n1. On cmder, i just start the virtual machine using vagrant ssh. \r\nvagrant@local8:/var/www/cgi/docroot$\r\nvagrant@local8:/var/www/cgi/docroot$ mysql -u root -h local8 -p\r\nEnter password: root\r\nmysql>\r\nWhen I run the above code, it asks for password, and I type 'root' and i get access to mysql\r\n\r\n2. The second way is through putty. I connect to the vagrant_ip: 192.168.25.8 mentioned in the config file. i input the following commands. \r\nlogin as: vagrant\r\nvagrant@192.168.25.8's password: vagrant\r\nvagrant@local8:/var/www/cgi/docroot$ mysql -u root -h local8 -p: root\r\nEnter password: root\r\nmysql>\r\n\r\nSame thing happens as the above\r\n\r\nCould you help me figure this out please?\r\n\r\n\r\n\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/geerlingguy/drupal-vm/issues/comments/311585722","html_url":"https://github.com/geerlingguy/drupal-vm/issues/1452#issuecomment-311585722","issue_url":"https://api.github.com/repos/geerlingguy/drupal-vm/issues/1452","id":311585722,"user":{"login":"jestinijames","id":28772215,"avatar_url":"https://avatars0.githubusercontent.com/u/28772215?v=3","gravatar_id":"","url":"https://api.github.com/users/jestinijames","html_url":"https://github.com/jestinijames","followers_url":"https://api.github.com/users/jestinijames/followers","following_url":"https://api.github.com/users/jestinijames/following{/other_user}","gists_url":"https://api.github.com/users/jestinijames/gists{/gist_id}","starred_url":"https://api.github.com/users/jestinijames/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jestinijames/subscriptions","organizations_url":"https://api.github.com/users/jestinijames/orgs","repos_url":"https://api.github.com/users/jestinijames/repos","events_url":"https://api.github.com/users/jestinijames/events{/privacy}","received_events_url":"https://api.github.com/users/jestinijames/received_events","type":"User","site_admin":false},"created_at":"2017-06-28T07:56:38Z","updated_at":"2017-06-28T07:56:38Z","body":"@geerlingguy , thanks for the help, but before you close the issue could you give me a sample code for:\r\n\r\n> But what @oxyc suggested is best—if at all possible, you should use a non-root user to do work with databases (and you can create additional users and databases by adding them to the mysql_users list in your config.yml, then running vagrant provision again).\r\n\r\n> "}}
{"actor":{"display_login":"jestinijames"}}