用户权限管理

用户管理

创建用户

CREATE USER [IF NOT EXISTS]
    user [auth_option] [, user [auth_option]] ...
    DEFAULT ROLE role [, role ] ...
    [REQUIRE {NONE | tls_option [[AND] tls_option] ...}]
    [WITH resource_option [resource_option] ...]
    [password_option | lock_option] ...

创建ip地址为192.168.1网段的连接用户：

CREATE USER username@'192.168.1.%' IDENTIFIED BY 'password';

创建全网段连接用户：

CREATE USER username@'%' IDENTIFIED BY 'password';