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

Categories: BSD, Linux

What to do when: mysqldump: Got error: 1044: Access denied for user ‘root’@’localhost’ to database ‘information_schema’ when using LOCK TABLES Add “–single-transaction” to your mysqldump string: $MYSQLDUMP –single-transaction -u $MUSER -h $MHOST -p”$MPASS” $db | $GZIP -9 > $FILE $MYSQLDUMP is the path of mysqldump executable.