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

评论

• 171楼
  2022年05月05日 13:12:37

  Shantae Swayne

  Hello, from CustomData.info we are a provider of unique databases that could help your business. Please visit us at CustomData.info to see if we can help you. Regards, Shantae

  回复
• 177楼
  2022年05月20日 03:25:44

  Odette Treadwell

  Your go-to source for leads. We can provide business to business and business to consumer leads, custom-tailored to your needs. CustomDatabases.org

  回复
• 178楼
  2022年06月23日 07:34:13

  Gaston Hobbs

  Hello, did you know that there are 241,120 internet directories in the world. These websites are what drive traffic to YOUR business. Want more traffic? Want more Sales? We can help - today. Your website itopers.com is listed in only 97 of these directories. Get more traffic for your Global audience. Our automated system adds your website to all of the directories. You can find it here: getlisted.directory/itopers.com Act today, and we will expedite your listings and waive the processing charge!

  回复
• 179楼
  2022年07月07日 13:52:30

  Madeleine Hower

  Convert itopers.com to an app with one click! 80% of users browse websites from their phones. Have the App send out push notifications without any extra marketing costs! MakeMySiteMobile.com

  回复
• 180楼
  2022年07月12日 22:19:34

  Cortney Embry

  Hello, did you know that there are 241,120 internet directories in the world. These websites are what drive traffic to YOUR business. Want more traffic? Want more Sales? We can help - today. Your website itopers.com is listed in only 97 of these directories. Get more traffic for your Global audience. Our automated system adds your website to all of the directories. You can find it here: getlisted.directory/itopers.com Act today, and we will expedite your listings and waive the processing charge! We have a special going on. Use "FRIENDS" on checkout for a 50% discount valid today.

  回复
• 181楼
  2022年09月21日 03:47:10

  Darrin Holyfield

  Hello. It is with sad regret to inform you LeadsTree.org is shutting down this week. We have made all our dataabses available at a one-time fee. LeadsTree.org

  回复
• 182楼
  2022年11月12日 14:52:57

  Garrett Armitage

  Hello, I regret to inform you that LeadsTree.org will shut down Friday. We have now made all our databases available to the public on our website at a one-time fee. Visit us at LeadsTree.org

  回复
• 183楼
  2023年02月18日 12:50:44

  Lizzie Gillingham

  Hello, MegaLeadsTree.com is shutting down. We have made available all our leads in 145 countries at a one-time fee. Visit us on MegaLeadsTree.com.

  回复
• 184楼
  2023年03月09日 11:45:56

  Darla Tarr

  DataList2023.com presents all the new leads for you per country! Visit us on DataList2023.com

  回复
• 185楼
  2023年03月22日 08:35:45

  Phillis Birmingham

  Hello, we visited itopers.com and noticed you do not have a mobile application. We have a service that provides mobile Apps to companies just like yours. You can learn more by visiting us on MakeMySiteMobile.com Regards, Phillis

  回复

发表评论