Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

localhost
userxxx
passxxx

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 mysql.something.com ?

Sorry, if this question is too basic.

share|improve this 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
add comment

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.

1 Answer

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
add comment

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