Topic: Mysql Connection Problems..

[Jesper Raben]

Hallo

I can't connect to my MySql server from the outside world, but i can connect on my local network !.

I have createt a user and a database and I wish to connect to this from the internet !.

I am sitting behind a router and i have opned port 3306 in the router, but i can't connect to the server ?

I am using SME Server 5.5

What am i doing wrong ???

/Jesper

[chris meredith]

Are you running in Secure Gateway mode?  I would bet the port is blocked by default from the outside world. You could manually add an ipchains/iptables rule depending on teh version you are running rule.  You could also use the port opening contrib and just do it that way.  

I don't know if you really want to just open up that port to the world like that though.  You could create a rule to only allow a connection to that port from the ip of the box(s) you plan on using as a sql client.  You might want to at least restrict the sql user account to connecting from a certain ip or ips.

[bud]

So all we have to do is open port 3306?  Nothing else?

[Benson]

Look at this !

http://forums.contribs.org/index.php?topic=15630.msg60186#msg60186

It helped me !

Hilsen Benson