Site5 Q&A » How do I access MySQL by external applications?

How do I access MySQL by external applications?

In: MySQL Asked By: Marlon [3

] Tags: Application, dns, External, MySQL, No-IP, Remote

I have added my IP in the Remote MySQL, and I can access mysql databases. But my ip changes because I am in a DSL connection, when it happen I can’t access again until change the ip in the Remote MySQL.

My question is can I use a dynamic DNS such as no-ip in the Remote MySQL? When I tryed I still can’t access my databases.

Thank you in advance.

3 Answers Answer this Question Now

Apr 22, 2013

Answer #1

Hello Marlon, on the Remote Database page, you may enter “%” which will allow access from any IP address which would be beneficial in this case. As always, ensure you are using strong passwords 🙂

Answered By: Yehzo [2

]

Answer #2

Hello Marlon,

I hope this comment finds you well!

Because of the way the remote database access works, a dynamic DNS provider would not work in this situation. This is because the Host/IP address (what our server sees) of your computer that is trying to access the server is not technically “in” the allowed list for remote hosts.

However, depending on how your ISP issues new IP addresses, you may be able to use an IP range. For example, if your IP always starts with “123.123…” you could put the host as “123.123.%.%”.

I hope this information helps and I hope you are able to find a solution that works for you.

If you have any questions, please feel free to leave a reply here, or if you would prefer, you can contact our support department directly by opening a ticket through Backstage.

Answered By: joliver [476

]

Answer #3

Hello,

The 2 answers worked like a charm.

Thank you!

Answered By: Marlon [3

]

Answer this Question

You must be Logged In to post an Answer.

Not a member yet? Sign Up Now »