{"action":"created","issue":{"url":"https://api.github.com/repos/chef-cookbooks/mysql/issues/401","repository_url":"https://api.github.com/repos/chef-cookbooks/mysql","labels_url":"https://api.github.com/repos/chef-cookbooks/mysql/issues/401/labels{/name}","comments_url":"https://api.github.com/repos/chef-cookbooks/mysql/issues/401/comments","events_url":"https://api.github.com/repos/chef-cookbooks/mysql/issues/401/events","html_url":"https://github.com/chef-cookbooks/mysql/issues/401","id":135194759,"number":401,"title":"Mysql 5.5 login failed","user":{"login":"sernapallyanurag","id":8936085,"avatar_url":"https://avatars.githubusercontent.com/u/8936085?v=3","gravatar_id":"","url":"https://api.github.com/users/sernapallyanurag","html_url":"https://github.com/sernapallyanurag","followers_url":"https://api.github.com/users/sernapallyanurag/followers","following_url":"https://api.github.com/users/sernapallyanurag/following{/other_user}","gists_url":"https://api.github.com/users/sernapallyanurag/gists{/gist_id}","starred_url":"https://api.github.com/users/sernapallyanurag/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sernapallyanurag/subscriptions","organizations_url":"https://api.github.com/users/sernapallyanurag/orgs","repos_url":"https://api.github.com/users/sernapallyanurag/repos","events_url":"https://api.github.com/users/sernapallyanurag/events{/privacy}","received_events_url":"https://api.github.com/users/sernapallyanurag/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2016-02-21T11:36:22Z","updated_at":"2016-09-08T15:14:08Z","closed_at":null,"body":"mysql_service 'sonar' do\r\n  port '3306'\r\n  version '5.5'\r\n  initial_root_password 'root'\r\n  action [:create, :start]\r\nend\r\n\r\nroot@xyz:~# mysql -S /var/run/mysql-sonar/mysqld.sock -u mysql -p\r\nEnter password: <root>\r\nERROR 1045 (28000): Access denied for user 'mysql'@'localhost' (using password:\r\nYES)\r\nroot@xyz:~# mysql -S /var/run/mysql-sonar/mysqld.sock -u root -p\r\nEnter password:\r\nERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Y\r\nES)"},"comment":{"url":"https://api.github.com/repos/chef-cookbooks/mysql/issues/comments/245631304","html_url":"https://github.com/chef-cookbooks/mysql/issues/401#issuecomment-245631304","issue_url":"https://api.github.com/repos/chef-cookbooks/mysql/issues/401","id":245631304,"user":{"login":"AneudyM","id":8399767,"avatar_url":"https://avatars.githubusercontent.com/u/8399767?v=3","gravatar_id":"","url":"https://api.github.com/users/AneudyM","html_url":"https://github.com/AneudyM","followers_url":"https://api.github.com/users/AneudyM/followers","following_url":"https://api.github.com/users/AneudyM/following{/other_user}","gists_url":"https://api.github.com/users/AneudyM/gists{/gist_id}","starred_url":"https://api.github.com/users/AneudyM/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AneudyM/subscriptions","organizations_url":"https://api.github.com/users/AneudyM/orgs","repos_url":"https://api.github.com/users/AneudyM/repos","events_url":"https://api.github.com/users/AneudyM/events{/privacy}","received_events_url":"https://api.github.com/users/AneudyM/received_events","type":"User","site_admin":false},"created_at":"2016-09-08T15:14:07Z","updated_at":"2016-09-08T15:14:07Z","body":"@sernapallyanurag, I think I figured out what the issue in my case was. It had to do with AppArmor. Do the following and see if that works for you:\r\n\r\n```\r\nsudo apt-get remove --purge mysql*\r\nsudo apt-get autoremove\r\nsudo apt-get clean\r\nsudo rm -rf `locate mysql`\r\nsudo apt-get remove --purge apparmor\r\n```\r\nNow do your `sudo chef-client` and see how that works for you. I am using a VirtualBox node with Ubuntu Server 14.04 LTS installed. "}}
{"actor":{"display_login":"AneudyM"}}