用户权限管理

– 创建用户
create user ‘user1’ identified by ‘123456’;

-- 简化版创建用户,谁都可以访问
create user user2;

– 删除用户
drop user user2;

– 修改用户密码
set password for “user1” = password(“654321”);

– 授予权限：grant
– 分配权限
grant select on mydatabase1.my_teacher to “user1”;
但只能看到my_teacher表

-- 取消权限：revoke
revoke all privileges on mydatabase.my_teacher from “user1”;

-- 刷新权限：flush
基本语法：flush privileges;

– 密码丢失的解决方案