mysql 5.7权限管理_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;

文章来源: blog.51cto.com，作者：wx5fa7501588701，版权归原作者所有，如需转载，请联系作者。

原文链接：blog.51cto.com/14995121/2547711