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
Share This