用户权限管理
– 创建用户
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;
– 密码丢失的解决方案