use dynamic ip to allow mysql remote access

[sergio rassino]

Hello. I need to allow remte mysql users to access a database. But as user's ip changes frecuently, I need to use a dynamic ip (as no-ip). Is it possible in Direct Admin? How can I solve that? Thanks

 

[Richard G]

It's not that easy. Check this thread please.

Thread 'Remote Access Host won't work with DYNDNS host'

Feb 15, 2021

Hello,

So I have my own DYNDNS host. For practicality purposes lets say it is:

myhost.dyndns.org

So I added this host to the allow Access Hosts list for the database in question.



For completion sake, I also added this to the csf.dyndns file through the CSF config section.



However, whenever I connect using MySQL workbench, the connection fails and says that I cannot connect using my own reverseDNS internet host.

Of course if I add my actual IP address in, it works fine but this defeats the purpose of DYNDNS.

I found this article online and they say to...

• bluesteam
• Replies: 13
• Forum: MySQL / PHP