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

  回复
• 7楼
  2021年03月25日 17:10:37

  Amy Eoff

  Hello, BestLocalData.com has a special package you get any group of databases for $49 or $249 for all 16 databases and unlimited emails for a year(Domain, IP, Dashboard included). You can purchase it on BestLocalData.com and see samples if you are interested.

  回复
• 8楼
  2021年04月08日 06:40:55

  Luisa Mcclanahan

  Hey, It was nice speaking to you the other day, this is the service I was telling you about that helped us boost our ROI almost 2000% Its a company called Lifemail.studio sorry it took so long to get back to you. They allow you to send any email doesn't matter what. We dealt with a guy named Michael, he was friendly and got us setup really quickly. Regards, Luisa

  回复
• 9楼
  2021年04月08日 17:18:35

  Pearlene Shimizu

  Hey, It was nice speaking to you the other day, this is the service I was telling you about that helped us boost our ROI almost 2000% Its a company called Lifemail.studio sorry it took so long to get back to you. They allow you to send any email doesn't matter what. We dealt with a guy named Michael, he was friendly and got us setup really quickly. Regards, Pearlene

  回复
• 10楼
  2021年04月14日 14:59:49

  Bess Shealy

  Hello, Send unlimited emails to unlimited lists with one click and no monthly fees! $99 once off! LifeMailNow.com

  回复

发表评论