备份时报错:mysqldump: Got error: 1142: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table
解决办法:加上--single-transaction,或者将参数CONFIG_mysql_dump_single_transaction设为'yes'即可。网上关于这个错误的解决方法也有设置--skip-lock-tables的
备份时报错:mysqldump: Got error: 1142: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table
解决办法:加上--single-transaction,或者将参数CONFIG_mysql_dump_single_transaction设为'yes'即可。网上关于这个错误的解决方法也有设置--skip-lock-tables的