使用mysqldump出错: $ mysqldump -h'192.168.1.21' -P3230 -u'un' -p'up' --where="id='1645519'" ud ut > s_d.txt mysqldump: Error: 'Access denied for user 'ud'@'%' to database 'INFORMATION_SCHEMA'' when trying to dump tablespaces这个问题是没有权限吗?要怎样授权?
GRANT priv_type [(column_list)] [, priv_type [(column_list)]] ... ON [object_type] {tbl_name | * | *.* | db_name.*} TO user [IDENTIFIED BY [PASSWORD] 'password'] [, user [IDENTIFIED BY [PASSWORD] 'password']] ... [REQUIRE NONE | [{SSL| X509}] [CIPHER 'cipher' [AND]] [ISSUER 'issuer' [AND]] [SUBJECT 'subject']] [WITH with_option [with_option] ...]object_type = TABLE | FUNCTION | PROCEDUREwith_option = GRANT OPTION | MAX_QUERIES_PER_HOUR count | MAX_UPDATES_PER_HOUR count | MAX_CONNECTIONS_PER_HOUR count | MAX_USER_CONNECTIONS countREVOKE priv_type [(column_list)] [, priv_type [(column_list)]] ... ON [object_type] {tbl_name | * | *.* | db_name.*} FROM user [, user] ...
加where条件导出,手动命令方式如何做呢?
$ mysqldump -h'192.168.1.21' -P3230 -u'un' -p'up' --where="id='1645519'" ud ut > s_d.txt
mysqldump: Error: 'Access denied for user 'ud'@'%' to database 'INFORMATION_SCHEMA'' when trying to dump tablespaces这个问题是没有权限吗?要怎样授权?
ON [object_type] {tbl_name | * | *.* | db_name.*}
TO user [IDENTIFIED BY [PASSWORD] 'password']
[, user [IDENTIFIED BY [PASSWORD] 'password']] ...
[REQUIRE
NONE |
[{SSL| X509}]
[CIPHER 'cipher' [AND]]
[ISSUER 'issuer' [AND]]
[SUBJECT 'subject']]
[WITH with_option [with_option] ...]object_type =
TABLE
| FUNCTION
| PROCEDUREwith_option =
GRANT OPTION
| MAX_QUERIES_PER_HOUR count
| MAX_UPDATES_PER_HOUR count
| MAX_CONNECTIONS_PER_HOUR count
| MAX_USER_CONNECTIONS countREVOKE priv_type [(column_list)] [, priv_type [(column_list)]] ...
ON [object_type] {tbl_name | * | *.* | db_name.*}
FROM user [, user] ...
错误提示说明,你的 'ud'@'% 没有访问数据字典的功能。
用MYSQL命令行登录一下,然后 show grants; 看一下你都有些什么权限。
mysql4的服务器,里面没有INFORMATION_SCHEMA库,那么不能使用条件导出了吧?