mysql权限管理

1、Mysql配置参数

1 从作用域上可分为 global和session
2 从类型上可分为‘可修改’和‘只读参数’
3 用户可不能在线修改只读参数，要修改只读参数，只能在配置文件中修改，并重启
4 所有参数的修改都不持久化

 2、用户权限管理

  • 常用权限
    SQL语句：SELECT,INSERT,UPDATE,DELETE,INDEX
存储过程：CREATE ROUTINE,ALTER ROUTING,EXECUTE,TRIGGER
管理权限：SUPER,RELOAD,SHOW DATABASE,SHUTDOWN,GRANT OPTION

     

    1 GREATE USER 'senior_dba'@'127.0.0.1' IDENTIFIED BY '123';
2 GRANT ALL ON *.* TO 'senior_dba'@'127.0.0.1';
3 GRANT ALL ON *.* TO 'senior_dba'@'127.0.0.1' IDENTIFIED BY '123' WITH GRANT OPTION;
4 开户用户对某段IP的访问许可
5 GRANT SELECT,INSERT,UPDATE,DELETE ON wp.* TO 'dev'@'192.168.246.%' IDENTIFIED BY '123456';
6 GRANT SELECT ON wp.wp_report TO 'report'@'192.168.246.%' IDENTIFIED BY '123456' WITH MAX_QUERIES_PER_HOUR 3 MAX_USER_CONNECTIONS 1;

     

  • 所有权限
    https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html

    https://dev.mysql.com/doc/refman/5.x/en/privileges-provided.html
     

     

posted on 2020-02-22 17:25  小舟868  阅读(159)  评论(0)    收藏  举报

导航