First, your work machine would need to have a static IP address and permanent Internet connection, and its firewall should be configured to allow access to port 3306 (or whatever port your MySQL installation uses).
Then, on your home machine, just point any client programs to use the IP address of your work machine and its MySQL port number. You could also install something like MySQL Control Centre if you like.
If your work MySQL installation is not already exposed to the world, then you would want to make sure that its passwords and user privileges are fairly tightly controlled before opening it up.
Not only will your work firewall need to allow access to port 3306, it will need to port-forward those requests to your work macine. (probably also wise to limit this to portforwarding rule to your own home IP adsress to).
If you dont use a firewll.... I recommend you get one , easiest to use and cheap as chips (ok free, but you supply the old pc) = smoothwall (
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.