数据库用户授权与视图

查询语句关键词排列顺序：

select / from / where (and/ or /not /liek /between and )/group by/ having/ order by (asc /desc)/ limit / offset

• 创建用户

flush privileges;
create user 'lulu'@'%' identified by '123456';

• 授予用户权限

-- 授予用户hrs数据库所有表的查询权限
grant select on hrs.* to