LinuxHelps.com

A blog for Linux Lovers.

Posted by sibu on October 10, 2009

MySQL information_schema error when using mysqldump utility

While executing the mysqldump command  you may have experienced following errors.

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.

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

Add A Comment