How to fix. mysqldump: Got error: 1142

Error: Things happened

When I tried to backup mysql by automysqlbackup, it showed folloing error message.

mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user
'root'@'localhost' for table 'cond_instances' when using LOCK TABLES

How to fix

Exclude 'performance_schema' mysql database that uses PERFORMANCE_SCHEMA storage engine.

/etc/automysqlbackup/automysqlbackup.conf

# List of DBNAMES to EXLUCDE if DBNAMES is empty, i.e. ().
CONFIG_db_exclude=( 'information_schema' 'performance_schema' )

ref.

Can't backup the mysql table with mysqldump. SELECT,LOCK TABL command denied for 'cond_instances' - Server Fault
http://serverfault.com/questions/268566/cant-backup-the-mysql-table-with-mysqldump-select-lock-tabl-command-denied-for