简单用法:
grant all on *.* to root@192.168.3.72 identified by 'abc123';
原语法:
grant all on *.* to root@192.168.3.72 identified by 'abc123';
原语法:
GRANTpriv_type
[(column_list
)] [,priv_type
[(column_list
)]] ...
ON [object_type
] {tbl_name
| * | *.* |db_name
.*}
TOuser
[IDENTIFIED BY [PASSWORD] 'password
']
[,user
[IDENTIFIED BY [PASSWORD] 'password
']] ...
[REQUIRE
NONE |
[{SSL| X509}]
[CIPHER 'cipher
' [AND]]
[ISSUER 'issuer
' [AND]]
[SUBJECT 'subject
']]
[WITHwith_option
[with_option
] ...]object_type
=
TABLE
| FUNCTION
| PROCEDUREwith_option
=
GRANT OPTION
| MAX_QUERIES_PER_HOURcount
| MAX_UPDATES_PER_HOURcount
| MAX_CONNECTIONS_PER_HOURcount
| MAX_USER_CONNECTIONScount