tag:support.appharbor.com,2010-11-23:/discussions/problems/20-no-rights-on-mysql-databaseAppHarbor: Discussion 2011-04-08T03:50:18Ztag:support.appharbor.com,2010-11-23:Comment/45297842011-01-02T23:17:15Z2011-01-02T23:21:58ZNo rights on MySQL database<div><p>After successful creation and access to a new MySQL database,
trying to create a new table I get the following error:</p>
<pre>
<code>mysql> create table users;
ERROR 1142 (42000): CREATE command denied to user 'dbXX'@'host.domain' for table 'users'</code>
</pre>
<p>("'dbXX'@'host.domain'" are not the real names).</p>
<p>Thanks<br>
Diego</p></div>Diego Caravanatag:support.appharbor.com,2010-11-23:Comment/45297842011-01-03T18:33:56Z2011-01-03T18:33:56ZNo rights on MySQL database<div><p>Hi Diego,</p>
<p>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.</p>
<p>Thanks a lot for reporting this issue!<br>
Rune</p></div>rune