+
8 rows in set (0.00 sec)

## 二、授权

grant [privileges] on db.table to ''user''@''host''

// 授予用户所有权限
grant all privileges on . to ''maqian''@''%''

## 三、修改用户密码

-- 当前用户
set password = password(''123456'')
-- 非当前用户
set password for ''user''@''host'' = password(''123456'')

## 四、取消授权

revoke [privilege] on db.table from ''user''@''host''

## 五、删除用户

drop user ''user''@''localhost''