How to link a database with ip whitelist by dynamic ip

what should you do if the ip of the server is dynamic and you want to connect to the database with ip whitelist on another server

I tried to fill in the whitelist of the database with the domain name after ddns, and found that it didn"t work. How do you solve this problem?

May.06,2022

if the database server uses an ip whitelist, it is useless for you to use ddns

the stupid way is to change the ip whitelist. Even if dhcp dynamically allocates ip, generally ip does not change much

in addition, use another server with the same ip as the relay and use iptables (if it is a linux server) to forward the data on this server

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e45166-44b0b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e45166-44b0b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?