{"action":"created","issue":{"url":"https://api.github.com/repos/emqx/emqx/issues/1927","repository_url":"https://api.github.com/repos/emqx/emqx","labels_url":"https://api.github.com/repos/emqx/emqx/issues/1927/labels{/name}","comments_url":"https://api.github.com/repos/emqx/emqx/issues/1927/comments","events_url":"https://api.github.com/repos/emqx/emqx/issues/1927/events","html_url":"https://github.com/emqx/emqx/issues/1927","id":374647498,"node_id":"MDU6SXNzdWUzNzQ2NDc0OTg=","number":1927,"title":"Failed to load the emq_auth_mysql plugins","user":{"login":"JiangLiguoME","id":23637343,"node_id":"MDQ6VXNlcjIzNjM3MzQz","avatar_url":"https://avatars2.githubusercontent.com/u/23637343?v=4","gravatar_id":"","url":"https://api.github.com/users/JiangLiguoME","html_url":"https://github.com/JiangLiguoME","followers_url":"https://api.github.com/users/JiangLiguoME/followers","following_url":"https://api.github.com/users/JiangLiguoME/following{/other_user}","gists_url":"https://api.github.com/users/JiangLiguoME/gists{/gist_id}","starred_url":"https://api.github.com/users/JiangLiguoME/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JiangLiguoME/subscriptions","organizations_url":"https://api.github.com/users/JiangLiguoME/orgs","repos_url":"https://api.github.com/users/JiangLiguoME/repos","events_url":"https://api.github.com/users/JiangLiguoME/events{/privacy}","received_events_url":"https://api.github.com/users/JiangLiguoME/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-10-27T13:52:35Z","updated_at":"2018-10-29T08:37:25Z","closed_at":null,"author_association":"NONE","body":"#### Environment\r\n\r\n- OS:      ubuntu 16.04LTS\r\n- Erlang/OTP: \r\n- EMQ: 2.3.1\r\n-MySQL: 5.7.3\r\n\r\n#### Description\r\nI just cannot load the emq_auth_mysql plugins.\r\n\r\nMy config is:\r\n##--------------------------------------------------------------------\r\n## MySQL Auth/ACL Plugin\r\n##--------------------------------------------------------------------\r\n\r\n## MySQL server address.\r\n##\r\n## Value: Port | IP:Port\r\n##\r\n## Examples: 3306, 127.0.0.1:3306, localhost:3306\r\nauth.mysql.server = 127.0.0.1:3306\r\n\r\n## MySQL pool size.\r\n##\r\n## Value: Number\r\nauth.mysql.pool = 8\r\n\r\n## MySQL username.\r\n##\r\n## Value: String\r\nauth.mysql.username = \"root\"\r\n\r\n## MySQL password.\r\n##\r\n## Value: String\r\nauth.mysql.password = \"my mysql passwd here\"\r\n\r\nThe log shows that:\r\n2018-10-27 21:46:50.138 [error] <0.1676.0> CRASH REPORT Process <0.1676.0> with 0 neighbours exited with reason: no match of right hand value {error,{shutdown,{failed_to_start_child,emq_auth_mysql,{shutdown,{failed_to_start_child,worker_sup,{shutdown,{failed_to_start_child,{worker,1},{1045,<<\"28000\">>,<<\"Access denied for user ''@'localhost' (using password: NO)\">>}}}}}}}} in emq_auth_mysql_app:start/2 line 33 in application_master:init/4 line 134\r\n\r\n*A description of the issue*\r\nI don't know why the emq cannot load my username or passwd!\r\nCan anyone help me?\r\nThanks.\r\n"},"comment":{"url":"https://api.github.com/repos/emqx/emqx/issues/comments/433827830","html_url":"https://github.com/emqx/emqx/issues/1927#issuecomment-433827830","issue_url":"https://api.github.com/repos/emqx/emqx/issues/1927","id":433827830,"node_id":"MDEyOklzc3VlQ29tbWVudDQzMzgyNzgzMA==","user":{"login":"terry-xiaoyu","id":11696433,"node_id":"MDQ6VXNlcjExNjk2NDMz","avatar_url":"https://avatars1.githubusercontent.com/u/11696433?v=4","gravatar_id":"","url":"https://api.github.com/users/terry-xiaoyu","html_url":"https://github.com/terry-xiaoyu","followers_url":"https://api.github.com/users/terry-xiaoyu/followers","following_url":"https://api.github.com/users/terry-xiaoyu/following{/other_user}","gists_url":"https://api.github.com/users/terry-xiaoyu/gists{/gist_id}","starred_url":"https://api.github.com/users/terry-xiaoyu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/terry-xiaoyu/subscriptions","organizations_url":"https://api.github.com/users/terry-xiaoyu/orgs","repos_url":"https://api.github.com/users/terry-xiaoyu/repos","events_url":"https://api.github.com/users/terry-xiaoyu/events{/privacy}","received_events_url":"https://api.github.com/users/terry-xiaoyu/received_events","type":"User","site_admin":false},"created_at":"2018-10-29T08:37:25Z","updated_at":"2018-10-29T08:37:25Z","author_association":"CONTRIBUTOR","body":"Remove the double quotation marks and try again, like this:\r\n```\r\n## Mysql Username\r\nauth.mysql.username = root\r\n\r\n## Mysql Password\r\nauth.mysql.password = emqtt\r\n\r\n## Mysql Database\r\nauth.mysql.database = mqtt_test\r\n```\r\n"}}
{"actor":{"display_login":"terry-xiaoyu"}}