Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I spoke with my host supporter to find what is my sql hostname.

He said that the only way is add permissions in mysql remote (cpanel) to my actual ip.

So the config in heidiSQL for example will be


But i have a dynamic ip, so i need to change the permissions every time, correct? Add the flag % probably is not a good idea, so how can I solve this problem?

Why I dont have something like ?

Sorry, if this question is too basic.

share|improve this question

closed as too localized by Michael Hampton, EEAA, Frands Hansen, voretaq7 Nov 6 '12 at 4:21

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

While I have voted to close this question, I'll give you a short pointer. I strongly advice against connecting to your MySQL from the outside. The simple reason being, that MySQL traffic is unencrypted - and such is the authentication of the connection. – Frands Hansen Sep 16 '12 at 22:12
@FrandsHansen the heidiSQL can work with ssl. – Fel Sep 16 '12 at 22:16

Have MySQL listen on localhost. Connect your SQL clients running on this system to localhost.

If you need to get in to MySQL from elsewhere either SSH into the box and use the command line client there, or SSH in and forward the MySQL port to your local machine using SSH port forwarding. No mucking about with dynamic IPs, and no exposing the MySQL port to the world for all and sundry to hack.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.