[大数据]MySQL DCL 数据控制语言

1.创建用户

create user '用户名' [@'主机名'][IDENTIFIED BY '密码']

2.修改密码

alter user '用户名' [@'主机名'] IDENTIFIED BY '密码'

3.删除用户

drop user '用户名' [@'主机名']

4.授权

grant all privileges on databaseName.tableName to?'用户名' [@'主机名']

5.撤销权限

revoke all privileges on databaseName.tableName from?'用户名' [@'主机名']

6.刷新权限

flush privileges

7.查看权限

show grant for ?'用户名' [@'主机名']