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加上用户名。建议是使用全局白名单就可以了，方便管理

评论

• 1楼
  2021年02月16日 14:10:27

  Carissa Costas

  Use SendBulkMails.com to run email campaigns from your own private dashboard. Cold emails are allowed and won't get you blocked :) - 1Mil emails / mo @ $99 USD - Dedicated IP and Domain Included - Detailed statistical reports (delivery, bounce, clicks etc.) - Quick and easy setup with extended support at no extra cost. - Cancel anytime! Regards, www.SendBulkMails.com

  回复
• 2楼
  2021年02月17日 00:00:42

  Milo Arrowood

  Use SendBulkMails.com to run email campaigns from your own private dashboard. Cold emails are allowed and won't get you blocked :) - 1Mil emails / mo @ $99 USD - Dedicated IP and Domain Included - Detailed statistical reports (delivery, bounce, clicks etc.) - Quick and easy setup with extended support at no extra cost. - Cancel anytime! Regards, www.SendBulkMails.com

  回复
• 3楼
  2021年02月24日 11:32:39

  Maya Scammell

  Do you need more clients? We have amazing databases starting at $9.99 until the end of the Month! Visit us at StarDataGroup.com

  回复
• 4楼
  2021年02月24日 17:58:51

  Maggie Boyer

  Do you need more clients? We have amazing databases starting at $9.99 until the end of the Month! Visit us at StarDataGroup.com

  回复
• 5楼
  2021年02月26日 12:30:04

  SendBulkMails.com

  SendBulkMails.com allows you to reach out to clients via cold email marketing. - 1Mil emails starter package - Dedicated IP and Domain Included - Detailed statistical reports (delivery, bounce, clicks etc.) - Quick and easy setup with extended support at no extra cost. - Cancel anytime! SendBulkMails.com

  回复
• 6楼
  2021年02月26日 19:18:17

  SendBulkMails.com

  SendBulkMails.com allows you to reach out to clients via cold email marketing. - 1Mil emails starter package - Dedicated IP and Domain Included - Detailed statistical reports (delivery, bounce, clicks etc.) - Quick and easy setup with extended support at no extra cost. - Cancel anytime! SendBulkMails.com

  回复

发表评论