[MYSQL]mysqldump: Got error: 104

mysqldump表时候，会出现表锁死情况，当前无权限dump数据
例如：

mysqldump --single-transaction -h1.1.1.1 -P1111 -umyuser -pmypass dbname tbname > tbname.sql
出现错误:
mysqldump: Got error: 1044: Access denied for user 'myuser'@'1.1.1.1' to database 'dbname' when using LOCK TABLES

解决方法：

加上 --single-transaction

mysqldump --single-transaction  -h1.1.1.1 -P1111 -umyuser -pmypass dbname tbname > tbname.sql

参考stack:https://dba.stackexchange.com/questions/86991/mysqldump-got-error-1044-access-denied-for-user-usernamelocalhost-to-dat