{"action":"created","issue":{"url":"https://api.github.com/repos/laravel-vue-book/be-fullstack-developer/issues/8","repository_url":"https://api.github.com/repos/laravel-vue-book/be-fullstack-developer","labels_url":"https://api.github.com/repos/laravel-vue-book/be-fullstack-developer/issues/8/labels{/name}","comments_url":"https://api.github.com/repos/laravel-vue-book/be-fullstack-developer/issues/8/comments","events_url":"https://api.github.com/repos/laravel-vue-book/be-fullstack-developer/issues/8/events","html_url":"https://github.com/laravel-vue-book/be-fullstack-developer/issues/8","id":373591663,"node_id":"MDU6SXNzdWUzNzM1OTE2NjM=","number":8,"title":"SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client","user":{"login":"budiodank","id":22407885,"node_id":"MDQ6VXNlcjIyNDA3ODg1","avatar_url":"https://avatars3.githubusercontent.com/u/22407885?v=4","gravatar_id":"","url":"https://api.github.com/users/budiodank","html_url":"https://github.com/budiodank","followers_url":"https://api.github.com/users/budiodank/followers","following_url":"https://api.github.com/users/budiodank/following{/other_user}","gists_url":"https://api.github.com/users/budiodank/gists{/gist_id}","starred_url":"https://api.github.com/users/budiodank/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/budiodank/subscriptions","organizations_url":"https://api.github.com/users/budiodank/orgs","repos_url":"https://api.github.com/users/budiodank/repos","events_url":"https://api.github.com/users/budiodank/events{/privacy}","received_events_url":"https://api.github.com/users/budiodank/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-10-24T17:24:00Z","updated_at":"2018-10-25T04:19:14Z","closed_at":null,"author_association":"NONE","body":"Cara mengatasinya\r\n\r\n1. tambahkan default authentication plugin to laradock/mysql/my.cnf\r\n```\r\n[mysqld]\r\ndefault_authentication_plugin= mysql_native_password\r\n```\r\n\r\n2. update content file mysql/docker-entrypoint-initdb.d/createdb.sql like:\r\n```\r\nCREATE USER 'admin'@'localhost' IDENTIFIED WITH mysql_native_password BY 'yourpass';\r\nGRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION;\r\nCREATE USER 'admin'@'%' IDENTIFIED WITH mysql_native_password BY 'yourpass';\r\nGRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' WITH GRANT OPTION;\r\n#\r\nCREATE DATABASE IF NOT EXISTS `yourdb` COLLATE 'utf8_general_ci' ;\r\nGRANT ALL ON `yourdb`.* TO 'admin'@'%' ;\r\nFLUSH PRIVILEGES ;\r\n```\r\nimportant note: remove old user, database and recreate again by above script.\r\n3. Remove mysql container and re-run it.\r\n`docker-compose rm mysql`\r\n\r\n`docker-compose up mysql`\r\n4. php artisan migrate is done :)\r\n5. kalo belum bisa atau muncul error\r\n`The server requested authentication method unknown to the client [caching_sha2_password]\")`\r\n6. buka phpmyadmin dan login\r\n`http://localhost:8080`\r\n7. Klik change password\r\n8. Masukkan passwordnya (seterah, tapi disarankan tetap `root`)\r\n9.Untuk password hashing pilih `Native Mysql authentication`\r\n10. Lanjut php artisan migrate\r\n\r\nLink Referensi \r\nhttps://github.com/laradock/laradock/issues/1392\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/laravel-vue-book/be-fullstack-developer/issues/comments/432909357","html_url":"https://github.com/laravel-vue-book/be-fullstack-developer/issues/8#issuecomment-432909357","issue_url":"https://api.github.com/repos/laravel-vue-book/be-fullstack-developer/issues/8","id":432909357,"node_id":"MDEyOklzc3VlQ29tbWVudDQzMjkwOTM1Nw==","user":{"login":"hscstudio","id":2976897,"node_id":"MDQ6VXNlcjI5NzY4OTc=","avatar_url":"https://avatars1.githubusercontent.com/u/2976897?v=4","gravatar_id":"","url":"https://api.github.com/users/hscstudio","html_url":"https://github.com/hscstudio","followers_url":"https://api.github.com/users/hscstudio/followers","following_url":"https://api.github.com/users/hscstudio/following{/other_user}","gists_url":"https://api.github.com/users/hscstudio/gists{/gist_id}","starred_url":"https://api.github.com/users/hscstudio/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hscstudio/subscriptions","organizations_url":"https://api.github.com/users/hscstudio/orgs","repos_url":"https://api.github.com/users/hscstudio/repos","events_url":"https://api.github.com/users/hscstudio/events{/privacy}","received_events_url":"https://api.github.com/users/hscstudio/received_events","type":"User","site_admin":false},"created_at":"2018-10-25T04:19:14Z","updated_at":"2018-10-25T04:19:14Z","author_association":"CONTRIBUTOR","body":"Yap benar, keren"}}
{"actor":{"display_login":"hscstudio"}}