Error #1044 - Access denied for user 'root'@'localhost' to database 'information_schema' [closed]
As Dan Grossman said:
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.
Open information_schema and run
FLUSH TABLESThis should clear the information_schema CACHE and will stop the error as it "resyncs" the tables to the latest schema
I use a program called Notepad++.
You open your sql file and the program will put it in a way where you can clearly see what the information_schema database is trying to do and why it is failing every time. You can safely remove that part of the database.
Then I install a WAMP on my pc, run a mysql program (mysql front) and import the database. After importing I have full access to the tables and databases.
Just export what you want and then just import then to your new database.