[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已经有了 lock tables的权限了!
mysqldump: Got error: 1045: Access denied for user 'csfdp'@'%' (using password: YES) when using LOCK TABLES
但是csfdp已经有了 lock tables的权限了!
解决方案 »
- autocommit
- access denied for user ''@'localhost'(using password:NO)
- 还是火车查询的问题,再问大家一个问题
- sum求和的语句,sum()在where中?
- Linux下MySQL中文乱码
- 期待高手解释下存储过程有什么具体作用,能有例子最好
- 求教数据查询时统计记录重复的问题
- mysql维护麻烦吗?
- 求助:下面的SQL语句如何优化?在Mysql中,7万条记录,查询需要8秒钟
- 项目是连接的mysql 现在需要换数据库 将数据库换成达梦数据库 我修改了配置文件 但是启动的时候就报错
- 特特特简单一个问题 你不知道的常识
- 如何优化以下SQL语句
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, SHOW VIEW ON `test`.* TO 'csfdp'@'%'
GRANT ALL PRIVILEGES ON `mdp`.* TO 'csfdp'@'%'
GRANT ALL PRIVILEGES ON `cdp`.* TO 'csfdp'@'%'
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, SHOW VIEW ON `um`.* TO 'csfdp'@'%'
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, SHOW VIEW ON `fdp`.* TO 'csfdp'@'%'
GRANT SELECT ON `reuters_rkd`.* TO 'csfdp'@'%'
GRANT SELECT ON `reuters_dss`.* TO 'csfdp'@'%'
GRANT SELECT ON `reuters_interface`.* TO 'csfdp'@'%'
GRANT ALL PRIVILEGES ON `sync_cdp`.* TO 'csfdp'@'%'
GRANT ALL PRIVILEGES ON `web_cdp`.* TO 'csfdp'@'%'
GRANT SELECT, LOCK TABLES, SHOW VIEW ON `web_cam`.* TO 'csfdp'@'%'
GRANT SELECT, LOCK TABLES, SHOW VIEW ON `web_fdp`.* TO 'csfdp'@'%'
在客户端如何试用 lock table命令呢?
执行 grant reload on sync_cdp.* to 'csfdp'@'%';报如下错误:
Error Code: 1221. Incorrect usage of DB GRANT and GLOBAL PRIVILEGES