mysql 5.5中mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' fo解決
在mysql5.5中,增加了performance_schema,當我們進行mysqldump的時候,會報如下錯誤信息:
mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES
我們可以mysqldump中加上參數 --skip-lock-tables
如下實例
mysqldump -uroot -p --skip-lock-tables performance_schema > performance_schema.sql