Re: DROP command denied to user

[Daniel Smythe]

If your database on your local machine has a different name than the database you're importing to godaddy, it's possible that the SQL in the dump is referencing the database, for instance;

USE 'localdatabasename';
DROP TABLE 'games';

Would throw an error since you will only have grants to the database name you're hosting.

One suggestion would be to run a find and replace on your local SQL file, and replace all occurrences of your local database name with your godaddy database name.

If that doesn't work, then you'll want to make sure that you're not using a read-only user to connect.

If all else fails, run the query SHOW GRANTS; from phpmyAdmin and have that information ready when you call support.