Mysql access

saran_redhat · 03-03-2010, 10:23 PM

hai

How to connect my mysql database server from outside network. because its locally works and i cant able to connect from outside and different networks. please advise me. when i try i am getting like this error.

ERROR 2003 (HY000): Can't connect to MySQL server on '123.136.126.179' (113)

Please advise me .

evo2 · 03-03-2010, 10:48 PM

There are a number of things that could be blocking this. These are the first that come to mind:

1. Firewall: is port 3306 open? (default mysql port)
2. TCPwrappers. Does /etc/hosts.allow have an entry like "mysqld: LOCAL, 192.168.0.0/255.255.255.0" assuming your ip range here.
3. mysql user account permissions: is there an entry in the mysql.users that will allow remote connection?

Cheers,

Evo2.

TB0ne · 03-04-2010, 12:26 PM

Quote:

Originally Posted by saran_redhat

hai

How to connect my mysql database server from outside network. because its locally works and i cant able to connect from outside and different networks. please advise me. when i try i am getting like this error.

ERROR 2003 (HY000): Can't connect to MySQL server on '123.136.126.179' (113)

Please advise me .

As evo2 said, those are all the things it could be. Did you try to Google this, because those are very common problems, with very well-known solutions....