Archived Support Site

This support site is archived. You can view the old support discussions but you cannot post new discussions.

MySQL access rights

Mikkel's Avatar

Mikkel

16 Feb, 2011 03:01 PM

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

  1. Support Staff 1 Posted by tt on 16 Feb, 2011 09:36 PM

    tt's Avatar

    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.

  2. tt closed this discussion on 16 Feb, 2011 09:36 PM.

  3. Mikkel re-opened this discussion on 16 Feb, 2011 10:09 PM

  4. 2 Posted by Mikkel on 16 Feb, 2011 10:09 PM

    Mikkel's Avatar

    Hi Troels,

    Thanks, views are working now -- but what about routines (procedures and functions), can you add those as well?

    Kind regards,
    Mikkel

  5. Support Staff 3 Posted by tt on 17 Feb, 2011 03:22 AM

    tt's Avatar

    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.

  6. tt closed this discussion on 17 Feb, 2011 03:22 AM.

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