Noticed my mysqldump script erroring out with the Error 1044, access denied when using LOCK TABLES.

Turns out this is due to the way some particular DBs are setup. If you have specified your DB to be InnoDB with UTF8, then attempting to use mysqldump like you normally would, may result in getting that error.

Fix: mysqldump -u root -p -h localhost dbname –single-transaction > db.backup.sql

This should dump all the tables in one transaction.