Site5 - Built For Designers & Developers MENU

How do I access MySQL by external applications?

[3 Grey Star Level]

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.

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 πŸ™‚

Answers Answered By: Yehzo [2 Grey Star Level]

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.

Answers Answered By: joliver [476 Blue Star Level]

Answer #3


The 2 answers worked like a charm.

Thank you!

Answers Answered By: Marlon [3 Grey Star Level]

Answer this Question

You must be Logged In to post an Answer.

Not a member yet? Sign Up Now »

Money Back Guarantees
Click to verify BBB accreditation and to see a BBB report.