Fixing mysqldump error: access denied for … when using LOCK TABLES
April 5th, 2010
I use the tool mysqldump to backup my databases today I wanted to backup a database but the following error occured (The command backups the database to the gzipped mydb.sql.gz file):
$ mysqldump -uuser -ppassword -hlocalhost mydb | gzip –best -c -f > /root/backups/db/mydb.sql.gz
mysqldump: Got error: 1044: Access denied for user ‘user’@'localhost’ to database ‘database’ when using LOCK TABLES
mysqldump: Got error: 1044: Access denied for user ‘user’@'localhost’ to database ‘database’ when using LOCK TABLES