How to solve mysqldump 1044 error

I do a database backup very ofter with mysqldump command.
Just found an error come when I run the command, mysqldump as below.

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

I google it and found one solution for it.

Add –single-transaction

$ mysqldump --single-transaction -u user -p DBNAME > backup.sql

Share on Facebook

Tweet

Related posts:

How to solve “Cannot retrieve metalink for repository: epel” Error in Centos 6 How to Solve the Virtualbox Bridged Adapter Problem Solve the login problem of Webmin in Centos Solve the Trouble with a cURL request in PHP Solve the problem of ffmpeg on Dreamhost Solve Data Problems and Increase Your Revenues PHP – Parse error: syntax error, unexpected end of file