查询语句关键词排列顺序:
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.*