Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

My ISP at home uses a dynamic IP address. I'm trying to access a MySQL database at work. How can I connect to it (using MySQL Workbench)?

I could grant all privileges to % so that any IP address will do, but I think this is NOT VERY SAFE. I don't know if granting privilege to my current IP Address will work.

If it does, it will still be tedious to grant privilege every time the IP changes.

Thanks in advance!

share|improve this question

4 Answers 4

Do you have the possibility to connect to your office network using a VPN? Then you could receive a static IP address in the range of your internal network. For this one, you could easily grant the necessary privileges.

share|improve this answer
    
never tried VPN before. But I think it is possible. Currently I'm using TeamViewer and I see a VPN version. I'll check that out. Thanks. –  Jairo Jun 15 '11 at 14:10
    
I can't access it using VPN :( –  Jairo Jun 16 '11 at 2:02

It looks like you can grant using a fqdn rather than an IP address - if that is right then you could make use of a dynamic DNS service such as DynDNS to get a stable DNS name that points to whatever your current home IP address is

share|improve this answer

You may need to contact your ISP with assistance on finding out your static IP. Once your find out, simple add root@'yourstaticIP' with the necessary grants.

You should also use the following options in /etc/my.cnf and restart mysql

[mysqld]
skip-host-cache
skip-name-resolve

Believe me, you need skip-host-cache and skip-name-resolve. Connecting to mysql without these options causes MySQL to authenticate via DNS, which is slow.

share|improve this answer

Connecting via DNS might be slower than IP but it is safer. I don't think setting skip name resolve is a good idea if this is a production server.

share|improve this answer
    
This is just a valid a reason is mine, although contrary to what I was thinking !!! +1 !!! –  RolandoMySQLDBA Jun 30 '11 at 20:37

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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