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

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

  1. Thanks

  2. 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.

  3. Thanks! I can confirm the problem on Squeeze with MySQL 5.1.49, and `–single-transaction` solves it.

  4. This is not a solution if you are using any other storage engine apart from INNODB.

  5. It worked

Leave a Reply