[spunkster21]

Awesome, thanks for the extra security tips. I'll be sure to implement.

[Andy]

www.hamachi.cc is a nice way to easily set up a VPN. You can also encrypt it with various methods too. I use it myself for connection to my computers when away from home. It avoids the use of portforwarding for every PC I connect to it.

[gigabit]

Use a ssh tunnel for extra security if you want.

[spunkster21]

Thank you all for the responses. I've managed to get it working perfectly.

[freshwire]

For the linux system it is by default listening on 127.0.0.1 only but in the case of windows I don't know. For linux you need to comment out the bind-address line in my.cnf

[Andy]

Using phpMyAdmin you can set up each user to listen on certain hosts. Set the host to your dedicated server IP and bob's your uncle.

[freshwire]

Is ODBC required. Can you not just listen on all interfaces for your mysql server and supply its hostname/ip as the server to connect to ? Filter with iptables to make it more secure if you want.

[spunkster21]

Hi all,

I'm currently renting an RPS server, which I use for hosting purposes, alongside a dedicated server, which I use for hosting game servers.

I have several server side plugins which rely on a MySQL DB, which I'm hosting on my RPS server.

I'm trying to figure out how to setup an ODBC driver, and configure it, so I can connect from my dedicated server to my RPS server.

I'm pretty sure I've got the ODBC drivers installed on the dedicated server, but I'm struggling with how to configure it to connect to the RPS MySQL database.

I'd appreciate any help.

Thanks.