MySQL information_schema error when using mysqldump utility

Sep 16

Some users report problem when backup is performed using mysqldump command line utility under the Linux OS. The version affected in our tests were 4.1.20.

mysqldump: Got error: 1044: Access denied for user ‘root’@’localhost’ to database ‘information_schema’ when using LOCK TABLES

To quickly fix this problem use the following switch when running mysqldump for MySQL database backups and upload to site.

mysqldump -u root -p –all-databases –single-transaction > all.sql

Filed under: Tips by Linux Admin

5 Responses to “MySQL information_schema error when using mysqldump utility”

Bruno, on January 17th, 2011 at 2:31 pm Said:

Thanks
Chris, on March 22nd, 2011 at 9:19 am Said:

Thanks for the tip! Never had the problem, but now I’m running MySQL 5.1.49 on Debian Squeeze and my backup script started to choke.
Juri, on April 26th, 2011 at 10:33 am Said:

Thanks! I can confirm the problem on Squeeze with MySQL 5.1.49, and `–single-transaction` solves it.
Aleks, on June 27th, 2011 at 6:33 pm Said:

This is not a solution if you are using any other storage engine apart from INNODB.
Vishwa, on September 28th, 2011 at 6:43 am Said:

It worked
Thanks

Linux server blog

MySQL information_schema error when using mysqldump utility

5 Responses to “MySQL information_schema error when using mysqldump utility”

Leave a Reply

Latest Blog posts:

Categories: