Skip to content

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

{ 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 *
E-mail It