Bingo!! With the installation of the 5.0 (I assume) skip-networking was set by default in /etc/mysql/my.cnf. That was it. Thanks. Mike
> 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]
