no insert permissions

I've successfully created a mysql + php website on windows azure following the steps here.

However, I do not have INSERT permissions on any of the tables in the database that I uploaded via a mysql > backup.sql command which seemed to migrate the database at the time but when using the website I can't do any inserts..

I did a show grants for (azure user) and it returned almost every command but insert, why is this?

Then I ran a GRANT INSERT ON dbname.* TO (azure user);

it says access denied for user '(azure user)' to database 'dbname'.

Please help me!

Jacob Griffith
1 person has
this problem