一、登录

mysql -u root -p

二、查看用户

select * from user;

三、新建用户

create user "username"@"host" identified by "password";

四、删除用户

drop user 'username'@'host'; /*删除用户*/

五、授权

# #####  授权 (多个权限用,隔开)  #######
grant all privileges on `cdn`.* to 'cdn'@'%'; /* 给予所有*/

grant select on cdn.* to 'a'@'%' IDENTIFIED BY '123456'; /*给予查询权限*/

grant insert on cdn.* to 'a'@'%'; /*添加插入权限*/

grant delete on cdn.* to 'a'@'%'; /*添加删除权限*/

grant update on cdn.* to 'a'@'%'; /*添加权限*/

grant update，delete on cdn.* to 'a'@'%'; /*添加权限*/

grant alter  on cdn.* to 'cdn'@'%'; /*添加权限*/


# 删除用户----------------------
    -- 
    drop user 'username'@'host'; /*删除用户*/

-- 通过删除mysql.user表数据的方式删除
    delete from user where user='用户名' and host='主机';
    flush privileges;




flush privileges;
/*刷新权限*/


# 查看某个用户权限
show grants for 'cdn'@'%';

# 删除用户权限 -----------------------------------------------------------------
revoke insert on cdn.* from 'cdn'@'%'; /* 删除用户insert权限 */

revoke delete on cdn.* from 'cdn'@'%'; /* 删除用户delete权限 */

revoke update on cdn.* from 'cdn'@'%'; /* 删除用户update权限 */

revoke select on cdn.* from 'cdn'@'%'; /* 删除用户select权限 */



# 查看用户有哪些权限 ----------------------------------------------------------------
show grants for '用户名'[@'主机']


revoke all privileges on cdn.* from 'cdn'@'%'; /* 删除用户所有权限 */