{"action":"created","issue":{"url":"https://api.github.com/repos/AsgardCms/Platform/issues/184","repository_url":"https://api.github.com/repos/AsgardCms/Platform","labels_url":"https://api.github.com/repos/AsgardCms/Platform/issues/184/labels{/name}","comments_url":"https://api.github.com/repos/AsgardCms/Platform/issues/184/comments","events_url":"https://api.github.com/repos/AsgardCms/Platform/issues/184/events","html_url":"https://github.com/AsgardCms/Platform/issues/184","id":139121163,"number":184,"title":"Check MySQL user privileges before proceeding with the installation","user":{"login":"kehugter","id":6382342,"avatar_url":"https://avatars.githubusercontent.com/u/6382342?v=3","gravatar_id":"","url":"https://api.github.com/users/kehugter","html_url":"https://github.com/kehugter","followers_url":"https://api.github.com/users/kehugter/followers","following_url":"https://api.github.com/users/kehugter/following{/other_user}","gists_url":"https://api.github.com/users/kehugter/gists{/gist_id}","starred_url":"https://api.github.com/users/kehugter/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kehugter/subscriptions","organizations_url":"https://api.github.com/users/kehugter/orgs","repos_url":"https://api.github.com/users/kehugter/repos","events_url":"https://api.github.com/users/kehugter/events{/privacy}","received_events_url":"https://api.github.com/users/kehugter/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2016-03-07T23:04:25Z","updated_at":"2016-04-19T15:09:39Z","closed_at":null,"body":"I created the Asgard MySQL user with the SELECT,INSERT,UPDATE,DELETE,CREATE,DROP privileges, which resulted in the following error when running `php artisan asgard:install`\r\n\r\n```\r\nDatabase successfully configured\r\n                                     \r\n  User Module                        \r\n  Starting the User Module setup...  \r\n                                     \r\nSQLSTATE[42000]: Syntax error or access violation: 1142 ALTER command denied to user 'asgard'@'localhost' for table 'persistences' (SQL: alter table `persistences` add unique `persistences_code_unique`(`code`))\r\n```\r\n\r\nI granted all privileges and ran `php artisan asgard:install` again, but the setup wouldn't resume/restart:\r\n\r\n    Asgard has already been installed. You can already log into your administration.\r\n\r\nThe privileges, if possible, should be checked before continuing. Adding the minimum required privileges for installing (and running, if different) Asgard in the documentation would be helpful, too."},"comment":{"url":"https://api.github.com/repos/AsgardCms/Platform/issues/comments/211971480","html_url":"https://github.com/AsgardCms/Platform/issues/184#issuecomment-211971480","issue_url":"https://api.github.com/repos/AsgardCms/Platform/issues/184","id":211971480,"user":{"login":"nWidart","id":882397,"avatar_url":"https://avatars.githubusercontent.com/u/882397?v=3","gravatar_id":"","url":"https://api.github.com/users/nWidart","html_url":"https://github.com/nWidart","followers_url":"https://api.github.com/users/nWidart/followers","following_url":"https://api.github.com/users/nWidart/following{/other_user}","gists_url":"https://api.github.com/users/nWidart/gists{/gist_id}","starred_url":"https://api.github.com/users/nWidart/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nWidart/subscriptions","organizations_url":"https://api.github.com/users/nWidart/orgs","repos_url":"https://api.github.com/users/nWidart/repos","events_url":"https://api.github.com/users/nWidart/events{/privacy}","received_events_url":"https://api.github.com/users/nWidart/received_events","type":"User","site_admin":false},"created_at":"2016-04-19T15:09:39Z","updated_at":"2016-04-19T15:09:39Z","body":"I think that if you want to setup custom privileges you are free to do so, as long as laravel has what it needs to access and write data."}}