mysql 5.7 用户添加与权限管理

新建用户 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;