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 entry was written by Stefano Borini, posted on November 8, 2008 at 3:54 pm, filed under MySQL. Bookmark the permalink. Follow any comments here with the RSS feed for this post. Trackbacks are closed, but you can post a comment.

Hemant Gandhi

Posted December 7, 2008 at 3:47 pm | Permalink

Nice and simple.
Most of the other posts I found wanted me to give the db user the right to look tables.
Asif

Posted February 16, 2009 at 5:34 pm | Permalink

Yes very simple and easy way to get it done.

its –single-transaction
Ganga

Posted February 4, 2010 at 5:51 pm | Permalink

That was simple and working! Thanks
Alex

Posted May 12, 2010 at 9:40 am | Permalink

Works perfectly.

How ?
sageperilous

Posted June 25, 2010 at 8:27 am | Permalink

Thanks a lot. It solved my problem
Pritesh

Posted July 13, 2010 at 4:14 pm | Permalink

Hi, Stefano,

you solution is excellant and resolve my issue

Thanks for such a simple soluction

-Pritesh

ForTheScience.org