A solution for ordinary users under mysql to backup databases without lock tables permissions

2020-05-12 06:20:06
OfStack

                    [root@ofstack.com]# mysqldump -u dbuser -ppass db 
>
 db.sql 

mysqldump: Got error: 1044: Access denied for user 'dbuser'@'localhost' to database 'db' when using LOCK TABLES 

Solution 1:

Plus the -skip-lock-tables option. That is:

[root@ofstack.com]# mysqldump -u dbuser -ppass db --skip-lock-tables 
>
 db.sql 

Solution 2:

Back up with a user with lock permissions.