Error 1044 in MySQL: Access denied when using LOCK TABLES

Written by Alexander • on March 19, 2010

Had some issues during a standard mysqldump. I have never encountered it before, and I have made similar dumps on identical mysql servers all day. Basically, it auto sets to lock tables somehow.

It is a reported bug at MySQL, and the page states that the bug is closed. According to the forums at MySQL it seemed to be an easy fix;

sql

GRANT SELECT,LOCK TABLES ON database.* TO 'username'@'localhost';

But I double checked, the user had ALL priviliges (yeah, not that safe). The same post mentioned above had a simpler solution that worked brilliantly:

shell-session

mysqldump -u username -p database --single-transaction >dump.sql

About the author

Hi! My name is Alexander, and I am a creative frontender, specializing in UX, accessibility, universal design, frontend-architecture, node and design systems. I am passionate with open source projects and love to dabble with new emerging technologies related to frontend. With over 26 years of frontend experience, I have earned the right to be called a veteran. I am a lover of life, technologist at heart. If I am not coding, I am cooking and I love whisky and cigars. Oh, and coffee, I LOVE coffee!

If you want to know more about me, here is some links you might want to check out: GitHub, Instagram, Twitter, LinkedIn, CodePen, Slides.com, npm,

Speaker

I am also an avid speaker on several topics! Check out some of the things I speak about, and contact me if you are interested in having me at your next event!