Linux server blog

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.

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

Filed under: Tips by Linux Admin