新建用户
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;
mysql 5.7 用户添加与权限管理
标签:应用 with option sele drop select 添加 erp 新建
本条技术文章来源于互联网,如果无意侵犯您的权益请点击此处反馈版权投诉
本文系统来源:https://blog.51cto.com/14995121/2547711