I've recently started using MySQL. I'm having success with it in genereal and am impressed by everything it can do. I've done all the stuff I want to do with it on my local machine and want to connect to it remotely (which is one of its most powerful features).
I have successfully connected to a remote mysql database hosted on my machine at work with a different machine on the network in work so I understand the whole GRANT thing, setting up users and hosts etc. Now I would like to run a MySQL database from my home machine and connect to it from work. I have set the appropriate users up but my confusion lies in what I need to configure on my firwall.
I have opened port 3306 to TCP connections (incoming and outgoing). Is there anyhting else I need to do - do I need to allow access to any particular applications etc? Do I have to start telnet services?
Any help on this matter would be great,
Bowettwow.
I have successfully connected to a remote mysql database hosted on my machine at work with a different machine on the network in work so I understand the whole GRANT thing, setting up users and hosts etc. Now I would like to run a MySQL database from my home machine and connect to it from work. I have set the appropriate users up but my confusion lies in what I need to configure on my firwall.
I have opened port 3306 to TCP connections (incoming and outgoing). Is there anyhting else I need to do - do I need to allow access to any particular applications etc? Do I have to start telnet services?
Any help on this matter would be great,
Bowettwow.