Re: DROP command denied to user
Posted by: Daniel Smythe
Date: August 24, 2009 01:58PM

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.

Options: ReplyQuote

Written By
July 27, 2009 07:31AM
Re: DROP command denied to user
August 24, 2009 01:58PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.