mysqldump: Got error: 1044: Access denied for user root@localhost to database information_schema when using LOCK TABLES

Table of Contents

Lỗi mysqldump: Got error: 1044: "Access denied for user 'root'@'localhost' to database 'information_schema'" when using LOCK TABLES

Nhận diện lỗi

Lỗi mysqldump: Got error: 1044: "Access denied for user 'root'@'localhost' to database 'information_schema'" when using LOCK TABLES

image

Cách sửa

https://www.cyberciti.biz/faq/linux-unix-mysqldump-got-error1044-access-denied/

mysqldump --single-transaction -u user -p DBNAME > backup.sql

Leave a Reply

Your email address will not be published. Required fields are marked *