{"action":"opened","issue":{"url":"https://api.github.com/repos/apetkau/orthomcl-pipeline/issues/4","labels_url":"https://api.github.com/repos/apetkau/orthomcl-pipeline/issues/4/labels{/name}","comments_url":"https://api.github.com/repos/apetkau/orthomcl-pipeline/issues/4/comments","events_url":"https://api.github.com/repos/apetkau/orthomcl-pipeline/issues/4/events","html_url":"https://github.com/apetkau/orthomcl-pipeline/issues/4","id":62404104,"number":4,"title":"Verify README instructions for setting up database.","user":{"login":"apetkau","id":200517,"avatar_url":"https://avatars.githubusercontent.com/u/200517?v=3","gravatar_id":"","url":"https://api.github.com/users/apetkau","html_url":"https://github.com/apetkau","followers_url":"https://api.github.com/users/apetkau/followers","following_url":"https://api.github.com/users/apetkau/following{/other_user}","gists_url":"https://api.github.com/users/apetkau/gists{/gist_id}","starred_url":"https://api.github.com/users/apetkau/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/apetkau/subscriptions","organizations_url":"https://api.github.com/users/apetkau/orgs","repos_url":"https://api.github.com/users/apetkau/repos","events_url":"https://api.github.com/users/apetkau/events{/privacy}","received_events_url":"https://api.github.com/users/apetkau/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-03-17T13:56:01Z","updated_at":"2015-03-17T13:56:01Z","closed_at":null,"body":"While I was testing this, I ran into issues when following the instructions for setting up the database https://github.com/apetkau/orthomcl-pipeline/blob/development/INSTALL.md.  In particular, after running `perl scripts/orthomcl-setup-database.pl ...` and then attempting to run the pipeline I run into issues like `DBD::mysql::st execute failed: CREATE VIEW command denied to user 'ortho3'@'localhost' for table 'InterTaxonMatch' at /home/aaron/Projects/software/orthomcl-pipeline/orthomclsoftware-custom/bin/orthomclInstallSchema line 184, <F> line 12.`.  I'm wondering if you have to add more statements to the `GRANT` command for this all to work.\r\n\r\nCan you look into this?  Thanks."}}