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

评论

• 21楼
  2021年08月27日 07:08:03

  Keira Countryman

  We have an amazing database of leads for you. All countries are $99 and you can buy the entire world 165 countries for $179. This offer is valid till Friday. www.SunDataGroup.one

  回复
• 22楼
  2021年08月28日 03:04:09

  Bernadette Tamayo

  We have an amazing database of leads for you. All countries are $99 and you can buy the entire world 165 countries for $179. This offer is valid till Friday. www.SunDataGroup.one

  回复
• 23楼
  2021年09月10日 21:28:54

  Eliza Brazil

  Hello from SunDataGroup.com We are selling leads from around the world. I thought your company could benefit from it. You can visit our website www.SunDataGroup.com to see some of our data. We have a special offer running. All our databases for $99.

  回复
• 24楼
  2022年03月08日 13:15:59

  Cynthia Hathaway

  Hello, It is with sad regret to inform you that DataList.biz is shutting down. We have made all our databases available for you at a one-time fee. You can visit us on DataList.biz Regards. Cynthia

  回复
• 25楼
  2022年03月21日 04:59:05

  Roseann McCathie

  Hi, I am interested in some of your products. Please give me a call on +1 304-873-4360

  回复
• 26楼
  2022年03月23日 19:32:54

  Frenchmxjf

  Whеn looking for wise words, the bеst onеs oftеn cоme from our еldеrs.

  回复
• 27楼
  2022年03月29日 01:57:13

  Roland Mulvany

  It is with sad regret to inform you DataList.biz is shutting down on 31 March 2022. We have made available databases per country for all companies available.. You can view our samples and download databases instantly on our website DataList.biz

  回复
• 33楼
  2022年04月14日 08:46:16

  Johan Fourie

  Hello. My name is Johan Fourie and I am looking to sell DataList.biz. We are a data company that has been in the industry for 12 years. We do around $170k/year in revenue. 1) I am looking to sell 50% of the business for $5k. 2) It would be helpful if you are knowledgeable about the Data Business. 3) I am looking for someone that is willing to take over administration, support, client relations. 4) I will continue to do the marketing for new products. 5) You will accept all future income and pay me from it. Please contact me on WhatsApp +27 72 280 1952 or my personal email: johanfourieinc@gmail.com if you are interested in this and we can have a call. Regards, Johan Fourie

  回复
• 34楼
  2022年04月15日 04:43:41

  Brayden Toothman

  ZippyLeads.org is running an easter special till the 18th of April. Get all the leads you need for your company with our easter special.

  回复
• 35楼
  2022年04月20日 13:35:42

  Hung Hardess

  Hello. It is with sad regret to inform you TopDataList.com is shutting down. We have made all our databases available for you for a once off fee. Visit us on TopDataList.com

  回复

发表评论