1.建立一个用户
在表中可以看到新建的用户gaofeng
2.--给gaofeng@192.168.65.81授权,拥有查询和修改mckkk库的所有表
grant select,update on mckkk.* to gaofeng@192.168.65.81 identified by 'qwer123!@#GF';
flush privileges;
--%匹配所有65段的用户拥有以下权限
grant select,update on mckkk.* to gaofeng@192.168.65.% identified by 'qwer123!@#GF';
flush privileges;