mysql grant 使用授权添加用户

全栈程序员站长

发布于 2021-04-30 14:56:48

2.7K0

简单用法:

grant all on *.* to root@192.168.3.72 identified by ‘abc123’;

原语法：

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
  | PROCEDURE

with_option =
    GRANT OPTION
  | MAX_QUERIES_PER_HOUR count
  | MAX_UPDATES_PER_HOUR count
  | MAX_CONNECTIONS_PER_HOUR count
  | MAX_USER_CONNECTIONS count

发布者：全栈程序员栈长，转载请注明出处：https://javaforall.cn/100605.html原文链接：

本文参与腾讯云自媒体同步曝光计划，分享自作者个人站点/博客。

如有侵权请联系 cloudcommunity@tencent.com 删除

root