Error 2003

[unixkamal]

Hi Team,

I am getting an error while trying to connect to my database system

which is

a production server.

My environment as fallows

Server

Redhat Linux 9

ssh implimented

Mysql Ver 3.23.54

Apache Server enabled

Client

Windows 2KPro

syslog 3.71

while trying to connect to system from client i am getting the below

error

Error No. 2003

Cannot connect to Server 192.16.2.10 (10054)

Can u help me in solving out this problem

Thanks in advance

[CalEvans]

Quote:

Error No. 2003

Cannot connect to Server 192.16.2.10 (10054)

Just a guess here but your pic gies a different IP address than the one in the quote above.

If that's just a typo then try the following standard mysql connection debugging steps.

0: Make sure the server is running.

1: If the server is outside of your network, make sure that port 3306 traffic is not being blocked by a firewall.

2: Make sure you can connect to the server from a client local to that server.

3: Make sure the server is listening to an IP address.

4: Make sure the server is listening to an IP address other than localhost.

5: Make sure WinXP's built in 'protection' as well as any personal firewalls are not blocking your traffic.

6: Try to connect from a different machine.

HTH,

=C=

[unixkamal]

Hi Evans!

Thanks for ur help, but the problem still remains

I have checked all the below credentials

0. Server is up and running fine .I found with ps -aux | grep mysqld . It is up and running

[root@bugzilla root]# ps -aux | grep mysqld

root 1102 0.0 0.0 4184 4 ? S Jun15 0:00 /bin/sh /usr/bin/safe_mysqld –defaults-file=/etc/my.cnf

mysql 1132 0.0 1.1 29408 2844 ? S Jun15 23:16 [mysqld]

root 29647 0.0 0.2 3568 624 pts/0 S 13:05 0:00 grep mysqld

1. The server and client falls under the same network of 172.16.0.0

Server: 172.16.2.8

Clinet: 172.16.3.97

These two are behind the firewall

2. The server is able to listen to IP address through ssh and NOT with telnet or ftp locally

3. The server is listning on to Client

4. My Client OS is Win 2K Professional

5. I installed the SQLyog in another machine and tried there also the same error (2003)

Can u pls check it out and help me to come from this issue ASAP

Thanks in advance

Kamal

Systems Engineer

[Versatile]

Are you certain that the computer where you're connecting from is allowed to acces ?

[unixkamal]

Yes, I am allowed to access the server from the client computer where the SQLyog is installed, I already installed SCRT in client which is having default ssh option from this terminal I usually controll the server regarding adding accounts or managing backup etc.

[Shadow]

SSL is the root of the problem. Check out this topic!

[Author]

Posts