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] ...]GRANT ALL PRIVILEGES ON 数据库名 TO '远程用户'@'远程IP'
GRANT ALL PRIVILEGES ON *.* TO 'aa'@'%'IDENTIFIED BY '123456' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO 'ab'@'120.227.164.34' IDENTIFIED BY '123456' WITH GRANT OPTION; GRANT create,drop,select,insert,update,delete ON database1.* TO 'abc'@120.227.164.34 IDENTIFIED BY '123456'; WEB可以链接但软件链接不上········
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] ...]GRANT ALL PRIVILEGES ON 数据库名 TO '远程用户'@'远程IP'
WEB可以链接但软件链接不上········