Take the 2-minute tour ×

I am using phpMyAdmin to import a .sql.zip database file into a remote host server and am getting the following error message:

error #1044 - Access denied for user

After researching this error, many people are saying this:

Check for information_schema and ensure all references, and table creation / data insertion queries for that database were removed

That's fine, but when I try to remove local references to the information_schema on my local WAMP server before exporting to a file, phpMyAdmin does not allow me to delete the information_schema table.

So how can I delete this table? Assuming that this is the best option to overcome this error.

share|improve this question
Did you see this thread? –  Leigh Jan 10 '13 at 3:11
"To "remove" information_schema from the dump, open the file in notepad and delete those lines. It's just a text file of sequential queries to run." –  Mr_leighman Jan 10 '13 at 12:04
Yes I did see the above thread, but its syill a massive five when you open up in notepad, not sure where to find and which actual references I should delete. –  Mr_leighman Jan 10 '13 at 12:05
I am not sure either, just thought I would point out that thread in case it helped. –  Leigh Jan 10 '13 at 14:53
add comment


Your Answer



Browse other questions tagged or ask your own question.