Hello,

I am facing a problem with remote mysql connection. I am not able to connect to mysql server. Its linux cpanel server and I have added access host % for the database user but not able to connect however few of my colleague is able to connect to server with the same logins but not me.
Some details from my side.

c:\>tracert xxx.xxx.xxx.xxx:3306

Unable to resolve target system name xxx.xxx.xxx.xxx:3306

c:\>

But 3306 is not blocked at my ISP end cause I am able to connect to mysql server from here to my other remote mysql server. My IP is not blocked anywhere on server as I have already by flushing the IPtables.

Can any body guide me ?

Thank you
Jason
http://blog.sysadminupdates.com

Greetings!

Does any one know some website from where I can check the remote mysql connection or can connect to my mysql server rather than from my computer so that I can atleast connect from my computer itself ?

Any help will be appreciated.
Thanks.
Jason.
http://blog.sysadminupdates.com

You can't traceroute to a port.

I am able to do that from a remote computer where I am able to connect to mysql database server.

C:\>tracert xxx.xxxx.xxx.xxx:3306

Tracing route to xxx.xxx.xxx.xxx:3306 [208.69.32.137]
over a maximum of 30 hops:

1 <1 ms <1 ms <1 ms 10.10.10.1
2 <1 ms <1 ms <1 ms 59.165.154.193.man-static.vsnl.net.in [59.165.15
4.193]
3 2 ms 2 ms 2 ms 59.165.154.13.man-static.vsnl.net.in [59.165.154
.13]
4 10 ms 10 ms 10 ms 59.163.16.162.static.vsnl.net.in [59.163.16.162]

5 10 ms 10 ms 10 ms 59.163.16.162.static.vsnl.net.in [59.163.16.162]

6 228 ms 228 ms 228 ms 59.163.16.146.static.vsnl.net.in [59.163.16.146]

7 310 ms 305 ms 305 ms if-12-2.icore1.NTO-NewYork.teleglobe.net [209.58
.26.13]
8 301 ms 300 ms 314 ms 209.58.26.22
9 305 ms 305 ms 308 ms 0.ge-5-2-0.XL4.NYC4.ALTER.NET [152.63.3.169]
10 312 ms 312 ms 321 ms 0.so-6-0-0.XL4.IAD8.ALTER.NET [152.63.0.130]
11 311 ms 311 ms 374 ms 152.63.36.65
12 330 ms 319 ms 320 ms 63.65.187.230
13 320 ms 317 ms 316 ms 208.69.32.137

Trace complete.

C:\>

xxx.xxx.xxx.xxx is my IP above.

Regards,
Jason
Http://blog.sysadminupdates.com

Try

telnet IP 3306

As far as telneting to a port, you can use tcptraceroute (not included in any repos) if you really wanted to. If telnet lets you in then it is the mysql hosts blocking your connection. If it does not and you are SURE iptables is clear it may be your ISP. While not something I would initially suspect perhaps they are blocking port 3306.

Greetings!

Nothing in telnet but I am able to telnet IP 3306 to other mysql server so its not blocked at my ISP.
As I said I am able to connect to other server with 3306 to mysql server but no this particular server. Iptables is already stopped on server so its not blocked on server.
Seems its blocked with 3306 in network but where?
Thanks for your help.

Jason
Http://blog.sysadminupdates.com