mysql5.5中mysqldump:Goterror:1142:SELECT,LOCKTABLcomm_MySQL

mysqldump

gaodaima.com

mysql 5.5中mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user &＃039;root&＃039;@&＃039;localhost&＃039; fo解决

在mysql5.5中，增加了performance_schema，当我们进行mysqldump的时候，会报如下错误信息：

mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user &＃039;root&＃039;@&＃039;localhost&＃039; for table &＃3本文来源gaodai#ma#com搞@@代~&码*网29;cond_instances&＃039; when using LOCK TABLES

我们可以mysqldump中加上参数 –skip-lock-tables

如下实例

mysqldump -uroot -p –skip-lock-tables performance_schema > performance_schema.sql

gaodaima.com