mysqldump的导表权限问题；

glq2000

求助mysqldump的导出表的权限的问题，如在进行如下导表操作的时候

mysqldump -uuser  -p  --tables  dbname tablename > a.sql
提示：
mysqldump: Got error: 1044: Access denied for user 'user'@'localhost' to database 'dbname' when doing LOCK TABLES

然后我看了下我这个用户的权限
mysql> show grants for user@'localhost' ;
+----------------------------------------------------------------------------------------------------------------------+
| Grants for user@localhost                                                                              
+----------------------------------------------------------------------------------------------------------------------+
| GRANT SELECT, DROP ON *.* TO 'user'@'localhost' IDENTIFIED BY PASSWORD 'XXXXXXXXXXX' |
+----------------------------------------------------------------------------------------------------------------------+

求教

1. 数据库的root用户，需要给这个user用户分配啥权限，才可用user这个用户来dump表数据呢？
2. 另外，mysqldump有没有啥参数，可以在导出表的时候，不要 lock整个table  ??

glq2000

换言之，只能是mysql的root用户，才可以导出表数据么？

glq2000

最后在mysql官网上找到结论了。


mysqldump requires at least the SELECT privilege for dumped tables, SHOW VIEW for dumped views, TRIGGER for dumped triggers, and LOCK TABLES if the --single-transaction option is not used. Certain options might require other privileges as noted in the option descriptions.


--single-transaction

This option sets the transaction isolation mode to REPEATABLE READ and sends a START TRANSACTION SQL statement to the server before dumping data. It is useful only with transactional tables such as InnoDB, because then it dumps the consistent state of the database at the time when START TRANSACTION was issued without blocking any applications.

lyhabc

解决了就好