Author Topic: mysqldump: Got error: 1142: "SELECT, LOCK TABLES  (Read 53 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
mysqldump: Got error: 1142: "SELECT, LOCK TABLES
« on: July 07, 2018, 10:33:14 AM »
Got an error in my daily MySQL backup:
Code: [Select]
Skipping database: information_schema.
Database Backup: mysql --> /backup/mysql/daily//mysql.sql
Database Backup: oauthv2 --> /backup/mysql/daily//oauthv2.sql
mysqldump: Got error: 1142: "SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'accounts'" when using LOCK TABLES
Database Backup: performance_schema --> /backup/mysql/daily//performance_schema.sql
Database Backup: postfix --> /backup/mysql/daily//postfix.sql
Database Backup: root_cwp --> /backup/mysql/daily//root_cwp.sql
Database Backup: roundcube --> /backup/mysql/daily//roundcube.sql

Anyway to solve this?