No rights on MySQL database

Diego Caravana's Avatar

Diego Caravana

02 Jan, 2011 11:17 PM

After successful creation and access to a new MySQL database, trying to create a new table I get the following error:

mysql> create table users;
ERROR 1142 (42000): CREATE command denied to user 'dbXX'@'host.domain' for table 'users'

("'dbXX'@'host.domain'" are not the real names).

Thanks
Diego

  1. Support Staff 1 Posted by rune on 03 Jan, 2011 06:33 PM

    rune's Avatar

    Hi Diego,

    seems like your database user account didn't get privileges to CREATE, DROP, ALTER and DELETE on the database. I've added these privileges to the user accounts on existing databases, so it should work now and with any new databases you may create.

    Thanks a lot for reporting this issue!
    Rune

  2. rune closed this discussion on 03 Jan, 2011 06:33 PM.

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