#创建用户
-- 语法:CREATE USER 用户名 IDENTIFIED BY '密码';
CREATE USER tt IDENTIFIED BY '123456';
-- 给TT用户授权(全部权限)
-- 语法:GRANT ALL PRIVILEGES ON 数据库名.表名 TO username
GRANT ALL PRIVILEGES ON *.* TO tt;
-- 查看用户权限
-- SHOW GRANTS FOR 用户名;
SHOW GRANTS FOR tt;
-- 语法:REVOKE ALL PRIVILEGES ON 库名.表名 FROM 用户名;
-- 取消tt用户所有权限
REVOKE ALL PRIVILEGES ON *.* FROM tt;
-- 修改tt密码
-- ALTER USER tt IDENTIFIED WITH mysql_native_password by '12345';
SET PASSWORD FOR 'tt'=PASSWORD('1234');
-- 删除用户
DROP USER tt;