Error #1044 - Access denied for user 'root'@'localhost' to database 'information_schema'

sql phpmyadmin information-schema
JonYork picture JonYork · Jan 28, 2011 · Viewed 95.5k times · Source

Alright, so here is the scenario

I performed a full backup on my mysql server today. Now when I try to import that .sql dump file, I get the error mentioned in the title and it does not load all the other databases.

How can I get around this so phymyadmin will allow me to import the whole file, or is there a way I could "remove" information_schema from the sql dump

Thanks

Answer

JonYork picture JonYork · Jan 28, 2011

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.

Related questions

MySQL: Can't create table (errno: 150)

I am trying to import a .sql file and its failing on creating tables. Here's the query that fails: CREATE TABLE `data` ( `id` int(10) unsigned NOT NULL, `name` varchar(100) NOT NULL, `value` varchar(15) NOT NULL, UNIQUE KEY `id` (`id`,`name`), …

Read More
Error Dropping Database (Can't rmdir '.test\', errno: 17)

Basically, I was taught on how to create a root password using the "mysqladmin -u root -p password" command, this was done all through the windows command editor. Now, the next process was to display the default databases (info. schema, …

Read More
PHP: maximum execution time when importing .SQL data file

I am trying to import a large .sql data file using phpMyAdmin in XAMPP. However this is taking a lot of time and I keep getting: Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampp\phpMyAdmin\libraries\dbi\…

Read More