Connect mysql with TOAD

[djansen1987]

Hi i'm running a small hosting server with direct admin installed on it.

Now a customer want to connect by only read to my server with the program TOAD. This is a program (told) to connect to a database en to better view tables etc.

Now they tell me i have to open a port 3306 to let the program work. but when i check my system-config-firewall-tui it seems that the firewall is disabled. other people tell me that i must not open port 3306 for security reasons.

in the program is also a option to connect trough ssh.

Could someone tell me how to set this up for my customer


thanks!!

 

[nobaloney]

I haven't a clue what system-config-firewall-tui is, but googling, it appears to be some kind of front end to the iptables firewall for Fedora.

So the real way to find out if you're running a firewall is to run:

# iptables -L

If you're not, I'd strongly suggest checking some of the firewalls discussed in these forums; they're all front ends to iptables, but the difference is that they're preconfigured for webhosting servers.

Even if you're not running a firewall, the specific database or the entire database system may need to be set up to allow access to databases from other than localhost.

Sure opening port 3306 raises a security flag; nevertheless, if your client needs remote access you're going to have to do it for him. If his desktop system is on a static IP#, then you should open MySql and port 3306 through your firewall just for his IP#.

Jeff