Author Topic: mysqldump: Got error: 1142  (Read 5970 times)

0 Members and 1 Guest are viewing this topic.

Offline
***
mysqldump: Got error: 1142
« on: November 07, 2017, 06:59:18 PM »
Hi,

I have the following row in the Daily Backup:

Daily MySQL Backup starting

Database Backup: mysql --> /backup/mysql/daily//mysql.sql
mysqldump: Got error: 1142: "SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'accounts'" when using LOCK TABLES



....is it a problem and how to fix it?

thanks in advance!

BR
Venty