My question is rather simple, I have a Windows 7 machine that is hosting an Apache server and a MySQL server using the XAMPP control panel. Both of these have been installed as a service on the machine. I am trying to connect to the MySQL server from a CentOS machine that is on the same LAN. When issuing the command:
mysql -h *IPADD* -u *UNAME* -p*PWORD*
I get this error:
ERROR 2003 (HY000): Can't connect to MySQL server on '172.26.96.166' (110)
I also see no indication in any logs on the Windows machine that there was a connection attempt.
I have spent much time trying to figure out a cause for this and I cannot seem to figure out the issue. I have:
Checked the firewall and explicitly made an exception for mysql
Installed MySQL as a service on the machine
Used the netstat command to verify that the ports are open
Checked and re-checked the username and password being used
Checked the host associated with the used credentials (the host is set to the wild card (
After doing all of this, I cant seem to find anything wrong or that would be blocking it. To give some sort of context, I am using this on a medium sized network and my account on the Windows machine is not Admin. However, I have had extensive help from an admin who has been the one authenticating me to change the firewall and what have you. That being said, there still may be restrictions on his account due to some grouping policies or the way the computer is imaged.
It may also be important to note that I am not directly in front of the CentOS machine, I am using "Putty" on the Windows machine to ssh into the machine to issue the MySQL commands
Anything I may have missed or any advice would be much appreciated.