mysqldump: Got error: 1044: Access denied for user ‘abc’@’localhost’ to database ‘info_abc’ when using LOCK TABLES
解决一:
加上-skip-lock-tables选项.
[root@cyq.me]# mysqldump -u dbuser -ppass db –skip-lock-tables
解决二:
使用root账户备份.
mysqldump: Got error: 1044: Access denied for user ‘abc’@’localhost’ to database ‘info_abc’ when using LOCK TABLES
解决一:
加上-skip-lock-tables选项.
[root@cyq.me]# mysqldump -u dbuser -ppass db –skip-lock-tables
解决二:
使用root账户备份.
VPS自动备份mysql是出错 mysqldump: Got error: 1044:等您坐沙发呢!