Skip to content
{ 2008 11 08 }

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

Posted by Stefano on Saturday, November 8, 2008, at 3:54 pm, and filed under MySQL. Follow any responses to this post with its comments RSS feed. You can post a comment, but trackbacks are closed.

{ 1 } Comments

  1. Hemant Gandhi | 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.

Post a Comment

Your email is never published nor shared. Required fields are marked *
Close
E-mail It