ProxySQL实例ip地址白名单：非白名单里的机器或者网段都提示not allow to connect db 未在白名单的机器，可以正常登录，但执行sql时才提示是否允许操作数据库。 delete from mysql_query_rules; INSERT INTO mysql_query_rules (rule_id,active,match_digest,destination_hostgroup,apply,flagIN) VALUES (10,1,'^SELECT.*FOR UPDATE',0,1,1),(20,1,'^SELECT',1,1,1); INSERT INTO mysql_query_rules (rule_id, active, client_addr, flagOUT, apply) VALUES (1,1,'10.10.1.138',1,0); INSERT INTO mysql_query_rules (rule_id, active, client_addr, flagOUT, apply) VALUES (2,1,'10.10.10.105',1,0); INSERT INTO mysql_query_rules (rule_id, active, client_addr, flagOUT, apply) VALUES (3,1,'10.27.%',1,0); INSERT INTO mysql_query_rules (rule_id, active, match_digest, error_msg, apply) VALUES (1000,1,'.','not allow to connect db',1); ProxySQL 1.4.8版本后开始支持ip地址%匹配 如上配置使用的是全局白名单，如果需要和用户名一起，可以使用username加上用户名。建议是使用全局白名单就可以了，方便管理

评论

• 186楼
  2023年04月02日 03:00:15

  Ana Auricht

  DataList2023.com

  回复
• 187楼
  2023年05月17日 13:38:35

  Refugia Dollar

  Hi, Your website is only listed in 8 out of a possible 12,489 directories. We are a service that lists your website in all these directories. Please visit us on DirectoryBump.com to find our more. Regards, Refugia Dollar

  回复
• 188楼
  2023年06月19日 03:44:45

  Shayla Brush

  It is with sad regret we are shutting down. We have made all our leads available for a one time fee on DataList2023.com Regards, Shayla

  回复
• 189楼
  2023年10月03日 02:59:28

  Isaac Edge

  Hey! Want some free leads or data for your business? Visit us: DataList2023.com

  回复
• 190楼
  2023年10月22日 13:32:04

  Emma Jacquez

  Hello, We noticed itopers.com is only listed in 8 out of 2500 directories. This severly impacts your backlinks and search engine rankings. Come get listed in all 2500 directories on DirectoryBump.com

  回复
• 191楼
  2024年01月30日 03:02:43

  Miguel Palazzi

  Hey! Come test out our beta project LeadsFly.biz and come get your free business leads. Regards, Miguel

  回复

发表评论