Mysqldump: Goterror: 1142: SELECT, LOCKTABLcom in mysql5.5

In mysql5.5, performance_schema is added. When we perform mysqldump, the following error message is returned: mysqldump: Goterror: 1142: SELECT, LOCKTABLcommanddeniedtouserroot @ login. We can use mysqldum.

In mysql5.5, performance_schema is added. When we perform mysqldump, the following error message is returned: mysqldump: Got error: 1142: SELECT, lock tabl command denied to user 'root' @ 'localhost' for table 'cond _ instances' when using lock tables we can mysqldum

In mysql5.5, performance_schema is added. When we perform mysqldump, the following error message is returned:

Mysqldump: Got error: 1142: SELECT, lock tabl command denied to user 'root' @ 'localhost' for table 'cond _ instances' when using LOCK TABLES

We can add the parameter -- skip-lock-tables to mysqldump as follows:

Mysqldump-uroot-p -- skip-lock-tables performance_schema> performance_schema. SQL

The above is the content of mysqldump: Got error: 1142: SELECT, lock tabl com in mysql5.5. For more information, see PHP Chinese Network (www.php1.cn )!