mysqldump: Got error: 1044: Access denied for user 'jpzen'@'localhost' to database 'information_schema' when using LOCK TABLES
原因:備份用戶缺乏 LOCK TABLES 權限,導致預設一致性鎖定失敗。
mysqldump -u your_user -p --single-transaction your_db > your_db.sql
LOCK TABLES 權限。mysqldump -u your_user -p --skip-lock-tables your_db > your_db.sql
GRANT SELECT, LOCK TABLES, SHOW VIEW, EVENT, TRIGGER ON *.* TO 'backup_user'@'localhost' IDENTIFIED BY 'pwd';
FLUSH PRIVILEGES;
--skip-lock-tables 易導致備份檔損壞/不一致,務必驗證還原。--single-transaction。