Quote:
Originally Posted by nosfentora
And is there a way to specify a different port for the db? i have my db @ home and don't like opening 3306 up, so i opened up another port in the virtual server section of my router page so it's a little more secure.
|
Yes, your mysql my.ini (or my.cnf, I don't remember which) file has the port number it listens on. You can change that to whatever you want.
If you're running a server on a linux system, you can also use openssh and putty to tunnel a port for mysql. This means you have to log in with putty first and then connect to the port on your computer that you set up to use for this.