mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user – for table...

Discussion in 'Linux News' started by Rob, Jul 24, 2014.

  1. Rob

    Rob Guest

    Have you seen this error before? This is because you’re trying to dump the performance_schema database while locking tables. The full error you received probably looks something like: mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user ‘root’@’localhost’ for table ‘cond_instances’ when using LOCK TABLES This probably means you’re trying to backup all of […]

    The post mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user – for table ‘cond_instances’ appeared first on Linux Brigade.

    Continue reading...

Share This Page