mysql中如何使用正则不允许对整表进行运作
发布时间：2021-12-26 17:59:43 所属栏目：MySql教程 来源：互联网
导读：这篇文章主要为大家展示了mysql中如何使用正则不允许对整表进行操作，内容简而易懂，条理清晰，希望能够帮助大家解决疑惑，下面让小编带领大家一起研究并学习一下mysql中如何使用正则不允许对整表进行操作这篇文章吧。 -- 禁止应用查看表结构 delete from mys
|
这篇文章主要为大家展示了“mysql中如何使用正则不允许对整表进行操作”，内容简而易懂，条理清晰，希望能够帮助大家解决疑惑，下面让小编带领大家一起研究并学习一下“mysql中如何使用正则不允许对整表进行操作”这篇文章吧。 -- 禁止应用查看表结构 delete from mysql_query_rules where rule_id=10006; INSERT INTO mysql_query_rules (rule_id, active,username,schemaname, match_pattern, error_msg,destination_hostgroup, apply) VALUES (10006,1,'yrzif_test2','yrzif_test2','^descs*S*','desc is not allowed',2,1); LOAD MYSQL QUERY RULES TO RUNTIME;SAVE MYSQL QUERY RULES TO DISK; -- 禁止应用对information_schema进行查询 delete from mysql_query_rules where rule_id=10007; INSERT INTO mysql_query_rules (rule_id, active,username,schemaname, match_pattern, error_msg,destination_hostgroup, apply) VALUES (10007,1,'yrzif_test2','yrzif_test2','s*S*information_schemas*S*','query on information_schema is not allowed',2,1); LOAD MYSQL QUERY RULES TO RUNTIME;SAVE MYSQL QUERY RULES TO DISK; -- 禁止对整表进行不加条件的查询 delete from mysql_query_rules where rule_id=10001; INSERT INTO mysql_query_rules (rule_id, active,username,schemaname, match_pattern, error_msg,destination_hostgroup, apply) VALUES (10001,1,'yrzif_test2','yrzif_test2','^SELECTs**s*froms*fi_user_bak$','Query not allowed',2,1); LOAD MYSQL QUERY RULES TO RUNTIME;SAVE MYSQL QUERY RULES TO DISK; -- 禁止对整表进行不加条件的删除 delete from mysql_query_rules where rule_id=1002; INSERT INTO mysql_query_rules (rule_id, active, username,schemaname,match_pattern, error_msg, apply) VALUES (1002,1,'yrzif_test2','yrzif_test2','^DELETEs*froms*fi_user_bak$','Query not allowed',1); LOAD MYSQL QUERY RULES TO RUNTIME;SAVE MYSQL QUERY RULES TO DISK; -- 禁止对整表进行不加条件的更新 delete from mysql_query_rules where rule_id=1003; delete from mysql_query_rules where rule_id=1004; delete from mysql_query_rules where rule_id=1005; INSERT INTO mysql_query_rules (rule_id, active,username,schemaname, match_digest, flagOUT, apply) VALUES (1003,1,'yrzif_test2','yrzif_test2','^updates*fi_user_bak', 100, 0); INSERT INTO mysql_query_rules (rule_id, active,username,schemaname, flagIN, match_digest, destination_hostgroup, apply) VALUES (1004,1,'yrzif_test2','yrzif_test2', 100, 'WHERE', 9, 1); INSERT INTO mysql_query_rules (rule_id, active,username,schemaname, flagIN, error_msg, apply) VALUES (1005,1, 'yrzif_test2','yrzif_test2',100, 'Query not allowed', 1); LOAD MYSQL QUERY RULES TO RUNTIME;SAVE MYSQL QUERY RULES TO DISK; 以上是“mysql中如何使用正则不允许对整表进行操作”这篇文章的所有内容，感谢各位的阅读！ （编辑：好传媒网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
