1. 创建用户
CREATE USER dong IDENTIFIED BY '123ws'
2. 修改密码(修改当前用户)
set password = PASSWORD('12112')
3. 修改密码(修改指定用户)
SET PASSWORD FOR dong = PASSWORD('12112')
4. 重命名
RENAME USER dong To dong1
5. 用户授权
GRANT ALL PRIVILEGES ON *.* TO dong1
6. 查询指定用户权限
SHOW GRANTS FOR dong1
7. 查询root权限
SHOW GRANTS FOR root
8. 撤销权限
REVOKE ALL PRIVILEGES ON *.* FROM dong1
9. 删除用户
DROP USER dong1