MySQL access rights
Hello,
It seems like I'm not allowed to create views and routines. Error output:
ERROR 1142: CREATE VIEW command denied to user
'db844'@'{HOST}' for table 'new_view'
Can you enable those rights for me?
Thanks :)
Kind regards,
Mikkel
Discussions are closed to public comments.
If you need help with AppHarbor please
start a new discussion.
Keyboard shortcuts
Generic
? | Show this help |
---|---|
ESC | Blurs the current field |
Comment Form
r | Focus the comment reply box |
---|---|
^ + ↩ | Submit the comment |
You can use Command ⌘
instead of Control ^
on Mac
Support Staff 1 Posted by tt on 16 Feb, 2011 09:36 PM
I've added the privilege to create views for your database. I'm scheduling a batch job to add the permissions to other MySQL databases as well.
tt closed this discussion on 16 Feb, 2011 09:36 PM.
Mikkel re-opened this discussion on 16 Feb, 2011 10:09 PM
2 Posted by Mikkel on 16 Feb, 2011 10:09 PM
Hi Troels,
Thanks, views are working now -- but what about routines (procedures and functions), can you add those as well?
Kind regards,
Mikkel
Support Staff 3 Posted by tt on 17 Feb, 2011 03:22 AM
I've added those rights as well. I didn't grant privilege for using the Event Scheduler, as we don't support that at the moment. Feel free to suggest it in case you need it.
tt closed this discussion on 17 Feb, 2011 03:22 AM.