mysqldumpselect_mysql5.5中mysqldump:Goterror:1142:SELECT,LOCKTABLcom

在mysql5.5中&＃xff0c;增加了performance_schema&＃xff0c;当我们进行mysqldump的时候&＃xff0c;会报如下错误信息&＃xff1a; mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user &＃39;root&＃39;&＃64;&＃39;localhost&＃39; for table &＃39;cond_instances&＃39; when using LOCK TABLES 我们可以mysqldum

在mysql5.5中&＃xff0c;增加了performance_schema&＃xff0c;当我们进行mysqldump的时候&＃xff0c;会报如下错误信息&＃xff1a;mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user &＃39;root&＃39;&＃64;&＃39;localhost&＃39;

for table &＃39;cond_instances&＃39; when using LOCK TABLES

我们可以mysqldump中加上参数 --skip-lock-tables 如下实例mysqldump -uroot -p --skip-lock-tables performance_schema > performance_schema.sql

以上就是mysql5.5中mysqldump: Got error: 1142: SELECT,LOCK TABL com的内容&＃xff0c;更多相关内容请关注PHP中文网(www.php.cn)&＃xff01;

本文原创发布php中文网&＃xff0c;转载请注明出处&＃xff0c;感谢您的尊重&＃xff01;