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

by

The error message “Got error: 1044: Access denied for user ‘root’@’localhost’ to database ‘information_schema'” indicates that the user ‘root’ does not have the necessary privileges to access the database ‘information_schema’ when using the LOCK TABLES option with mysqldump.

To resolve this issue, you can either:

  1. Grant the necessary privileges to the user ‘root’ by executing the following command in the MySQL prompt:
GRANT SELECT, LOCK TABLES ON information_schema.* TO 'root'@'localhost';
  1. Use the --skip-lock-tables option when running mysqldump:
mysqldump --skip-lock-tables -u root -p database_name > database_name.sql

This option allows you to bypass the use of LOCK TABLES and avoid the error.

Leave a Comment