Error: MySQL error Number 2003(10065)

[John Black]

I an getting the error message - MySQL error Number 2003
Can't connect to MySQL server on 'IP_Address' (10065) - when I try to connect to the MySQL server 4.1.12 install running in a CEntOS4 virtual machine on my Windows XP laptop. Here is the setup and what I have tried so far:

OS CEntOS 4.3
DB MySQL 4.1.12
Client Windows XP SP2

CEntOS4 is running in a VMware 5.5.4 VM on the XP box

The hosts.deny file is blank. The hosts.allow file contains only ALL:ALL

**************************************
# ps -ef | grep mysqld
root 1636 1 0 09:40 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --pid-file=/var/run/mysqld/mysqld.pid
mysql 1666 1636 0 09:40 ? 00:00:01 /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
root 2803 2754 0 09:49 pts/0 00:00:00 grep mysqld
*************************************
# netstat -lnp | grep mysql
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 1666/mysqld
unix 2 [ ACC ] STREAM LISTENING 3796 1666/mysqld /var/lib/mysql/mysql.sock

********************************************
mysql> show variables like "port";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port | 3306 |
+---------------+-------+
1 row in set (0.00 sec)

mysql>
********************************************
The contents of MY.CNF
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
****************************************
mysql> show variables like "socket";
+---------------+---------------------------+
| Variable_name | Value |
+---------------+---------------------------+
| socket | /var/lib/mysql/mysql.sock |
+---------------+---------------------------+
1 row in set (0.00 sec)

mysql>

*********************************************

XP Windows firewall on MySQL port TCP/3306 is allowed to any computer
also tried with firewall disabled.

********************************************

Tried to connect with MySQL Administrator 1.0.21 with the following settings:

Server Host IP of server
Username user with all rights from host %
Password user's password
Port 3306

I hace also tries MySQL Control Center and WinSQL applications with the same error.

Error:

Could not connect to specified instance.
MySQL error Number 2003
Can't connect to MySQL server on 'IP_Address' (10065)

Does anyone have ant other suggestions?



Edited 1 time(s). Last edit at 08/24/2007 11:27AM by John Black.