Forums

I just created my first DB from my dashboard and when I try to create a table I get this error: ERROR 1142 (42000): CREATE command denied to user 'cnicholls'@'ip-10-150-79-66.ec2.internal' for table

I don't know where I went wrong. any help?

I solved my issue.. it was a pretty boneheaded mistake but I'll post it here in case anyone runs into the same thing. I was trying to run the create table statements from a .sql script and I had the schema name in the create statements and it was different from the database i was trying to create it in. ie it was

CREATE table foo.bar ( .... I took out the foo. and it is working fine now

Good catch! Thanks for sharing that :-)