Error 1044 in MySQL: Access denied when using LOCK TABLES

解决这个问题，需要管理员给你的用户lock的权限才行，或者用下面的命令：

mysqldump -u username -p database --single-transaction >dump.sql

--single-transaction
          Creates a consistent snapshot by dumping all tables in a
          single transaction. Works ONLY for tables stored in
          storage engines which support multiversioning (currently
          only InnoDB does); the dump is NOT guaranteed to be
          consistent for other storage engines. While a
          --single-transaction dump is in process, to ensure a
          valid dump file (correct table contents and binary log
          position), no other connection should use the following
          statements: ALTER TABLE, DROP TABLE, RENAME TABLE,
          TRUNCATE TABLE, as consistent snapshot is not isolated
          from them. Option automatically turns off --lock-tables.