Error 1044 in MySQL: Access denied when using LOCK TABLES
I got an error while using mysqldump
*mysqldump: Got error: 1044: Access denied for user x\@y to database z when using LOCK TABLES*
To solve this problem, either ask you administrator to grant you the lock privileges, or use the following command instead.
mysqldump -u username -p database --single-transaction >dump.sql
This is the help entry for the keyword
--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.