create user read_user@‘192.168.10.%‘ identified by ‘read123‘;
修改用户密码
alter user read_user@‘192.168.10.%‘ identified by ‘read123456‘;
权限列表
ALL
SELECT ，INSERT UPDATE CREATE DROP RELOAD
with grant option
授权命令
grant all on . to read_user@‘192.168.10.%‘ identified by ‘read123‘ with grant option；
grant 权限 on 作用目标 to 用户 identified by ‘read123‘ with grant option；
授权需求
1 创建一个管理员用户,可以通过10网段，管理数据库
grant all on . to root@‘192.168.10.%‘ identified by ‘root123‘ with grant option;
2 创建一个应用用户,可以通过10网段，erp库下的所有表进行 SELECT,INSERT,UPDATE,DELETE.
grant SELECT,INSERT,UPDATE,DELETE on erp.* to erp@‘192.168.10.%‘ identified by ‘erp123‘ with grant option;
3.创建只读用户
grant SELECT on . to readuser@‘192.168.10.%‘ identified by ‘read123‘ with grant option;