mysqldump: Got error: 1044: Access denied for user to database '' when doing LOCK TABLES

mysql 问题集
一个问题
Publish Date:   2021-01-27

开发环境

mysqldump  Ver 10.17
MySQL [5.5.32-log]

问题描述

mysqldump --host="DB_HOST" --port=DB_PORT --user="DB_USER" --password="DB_PWD" -t "DB_NAME" "TBL_NAME" --where="1=1 limit OFFSET,LIMIT" > "/paht/to/storage/TBL_NAME-OFFSET-LIMIT.sql"

执行脚本的时候,提示用户没有权限锁表.

mysqldump: Got error: 1044: "Access denied for user  to database ''" when doing LOCK TABLES

解决方案

在导出的语句中, 添加 --skip-opt 参数即可!

mysqldump --skip-opt --host="DB_HOST" --port=DB_PORT --user="DB_USER" --password="DB_PWD" -t "DB_NAME" "TBL_NAME" --where="1=1 limit OFFSET,LIMIT" > "/paht/to/storage/TBL_NAME-OFFSET-LIMIT.sql"

参考文档

Author: Itaken
Link: https://itaken.github.io/2021/1/27/%E6%95%B0%E6%8D%AE%E5%BA%93%E5%AF%BC%E5%87%BA%E9%94%81%E8%A1%A8%E5%A4%84%E7%90%86/
Reprint policy: All articles in this blog are used except for special statements CC BY 4.0 reprint polocy. If reproduced, please indicate source Itaken !
mysql 问题集
  TOC目录