2021-08-08

-- 创建用户

CREATE USER pangiggs IDENTIFIED BY '123456'

-- 修改当前密码
SET PASSWORD = PASSWORD '123456'

-- 修改指定用户密码
SET PASSWORD FOR pangiggs = PASSWORD ('123456')

-- 重命名用户
RENAME USER pangiggs TO panpan

-- 授予全部权限
GRANT ALL PRIVILEGES ON *.* TO panpan

-- 查看权限
SHOW GRANTS FOR panpan
SHOW GRANTS FOR root@localhost

-- 撤销权限 全部 所有表，库的权限
REVOKE ALL PRIVILEGES ON *.* FROM panpan

-- 删除用户
DROP USER panpan