Connect to database by remote host

[onh1986]

Hello
I want to connect to database in my website by remote host (e.g. MySQL Query Browser)

How?

Thanks & Regards

 

[DirectAdmin Support]

Hello,

1) Make sure port 3306 is open
2) Add an access host to allow yourself to connect to mysql:
User Level -> MySQL management -> username_dbname -> Add Access Host

Either add your local ip address, or add:
%
to allow any IP to connect (if you don't know your IP).
The user/pass is still needed with %.

John

 

[onh1986]

How to make sure port 3306 is open?

 

[DirectAdmin Support]

From your remote machine (your home computer), load up a cmd window, and type:

telnet yourhost.com 3306

If it connects, then it's open.

John

 

[onh1986]

It couldn't connect.
Port 3306 isn't open.

Can I connect by another port???

 

[DirectAdmin Support]

Hello,

shut off your firewall:

/sbin/service iptables stop

to open up port 3306.

John

 

[onh1986]

Where can I find /sbin/service iptables stop?

Thanks

 

[DirectAdmin Support]

Root access via ssh, assuming you're using linux.
Contact your server admin if you don't know what I'm talking about

John

 

[nobaloney]

And once you've done your testing, be sure to open a hole in your firewall, and turn it back on.

Jeff