Re: Can't connect (error 2003) to mysql 5.0 on other server

[Michael Stassen]

I assume you have already verified that the mysql server is actually running 
on server A.  Have you verified that server A is accepting tcp connections? 
 Try running

  mysql -h mycompA -u mysql -p

from server A.  If it lets you in, try

  SELECT CURRENT_USER();

just to make sure it says @mycompA rather than @localhost.  Alternatively, try

  telnet mycompA 3306

from both machines to see if you get an answer.

If it doesn't let you in, check to see if mysql was started with 
--skip-networking on A, and look for anything which blocks mysql's port.

Michael

Mike Bosschaert wrote:

Hi,
I installed mysql 5.0 on server A and mysql 4.0 on server B. Starting 

mycompA$>mysql -h mycompB -u mysql -p 

on host A, I can connect and to the mysql-server on host B. However when I 
start 

mycompB$>mysql -h mycompA -u mysql -p

on host B, I get the error message:
ERROR 2003: Can't connect to MySQL server on 'mycompA' (111)
On mycompA the user [EMAIL PROTECTED] has all privileges.

This is what tcpdump reports:
tcpdump: listening on eth1 port 3306
13:50:32.732182 mycompB.33431 > mycompA.mysql: S 2312810184:2312810184(0) win 
5840 <mss 1460,sackOK,timestamp 11242088 0,nop,wscale 0> (DF)
13:50:32.732570 mycompA.mysql > mycompBt.33431: R 0:0(0) ack 2312810185 win 0 
(DF)

Any suggestions?

Mike



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]