mysqldump: Got error: 1045: Access denied for user ...... when using LOCK TABLES

1728阅读 0评论2014-06-07 mchdba
分类:数据库开发技术

[root@csfdpdev data]# mysqldump -ucsfdp -pcsfdp sync_cdp > sync_cdp_26_20110915.sql
mysqldump: Got error: 1045: Access denied for user 'csfdp'@'%' (using password: YES) when using LOCK TABLES


但是csfdp已经赋予了再sync_cdp库上的lock tables的权限了!
 
 
上一篇:最伤感最纠结的不是得不到和已失去,而是 对不起
下一篇:mysqldump: Got error: 1045: Access denied for user when using LOCK TABLES