MySQL returns error 2002 (10060) when connecting to remote

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MySQL returns error 2002 (10060) when connecting to remote

Postby whatsup » 16. August 2012 10:11

Hi folks,

I have XP SP3 with following "XAMPP Portable" setup:
Code: Select all
###### ApacheFriends XAMPP (Basispaket) version 1.7.4 ######
  + Apache 2.2.17
  + MySQL 5.5.8 (Community Server)
  + PHP 5.3.5 (VC6 X86 32bit) + PEAR
  + XAMPP Control Version 2.5 from www.nat32.com
  + XAMPP Security
  + SQLite 2.8.15
  + OpenSSL 0.9.8o
  + phpMyAdmin 3.3.9
  + ADOdb 5.11
  + Mercury Mail Transport System v4.62
  + FileZilla FTP Server 0.9.37
  + Webalizer 2.01-10
  + Zend Optimizer 3.3.0
  + Perl 5.10.1
  + Mod_perl 2.0.4
  + Tomcat 7.0.3


On same system, i have MySQL/ODBC connector, which works fine. Now, i've tried to connect from second computer with same settings, and MySQL refuses connection.
I've tried:
1. MySQL user's hostmask is "%"
2.a) uncomment lines in my.ini which block remote connections
2.b) Bound listening IP address to 0.0.0.0 ("all")
3. changed socket from "D:/Xampp/mysql/mysql.sock" to "TCP/IP" and also tried "D:/Xampp/mysql/TCP/IP.sock" (which sounds mega-wrong because of slash in "tcp/ip")
and none of this works.

Here's the screenshot:
Image

What am i doing that wrong?

PS. note that i've tried to use BBCode which puts a thumbnail of picture and links to bigger one, but forum blocked, therefore i've needed to put whole picture. Thank you!
whatsup
 
Posts: 3
Joined: 16. August 2012 10:03
Operating System: Windows XP Professional SP3

Re: MySQL returns error 2002 (10060) when connecting to remo

Postby JonB » 17. August 2012 02:49

Personally -I'd start by temporarily disabling that connector

the 10060 says its an OS error - might be a firewall issue.

this might be helpful
http://ftp.nchu.edu.tw/MySQL/doc/refman ... enied.html

Good Luck
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: MySQL returns error 2002 (10060) when connecting to remo

Postby whatsup » 17. August 2012 09:38

Now that was interesting :)

I've started to fiddle with combos of firewalls (local on/of, remote(server) on/off), which i've DID before, but haven't come to this:
"Can't get hostname for your address" (before, i got just that 2002 (10060/10061) error)

Google helped, and found out.
Added "skip-name-resolve" in my.ini and reboot mysql.
Works like a charm, now server "MyODBC" is connected to localost same time as 192.168.1.141's "MyODBC" is connected to MySQL server :)

Just for a note, i've added allow-TCP-3306 to firewall rules. Just in case :)
whatsup
 
Posts: 3
Joined: 16. August 2012 10:03
Operating System: Windows XP Professional SP3

Re: MySQL returns error 2002 (10060) when connecting to remo

Postby whatsup » 17. August 2012 10:03

whatsup wrote:Added "skip-name-resolve" in my.ini and reboot mysql.


And now , when going to localhost/phpmyadmin, logging as root with proper password... :)


Code: Select all
#1045 Cannot log in to the MySQL server
Connection for controluser as defined in your configuration failed.

Which is silly when you want to login as root quickly, but well. I guess that if i fix that with commenting skip-name-resolve, i get back to MySQL/ODBC errors

Oh well :)
whatsup
 
Posts: 3
Joined: 16. August 2012 10:03
Operating System: Windows XP Professional SP3

Re: MySQL returns error 2002 (10060) when connecting to remo

Postby JonB » 17. August 2012 15:52

Did you set the pma user password and patch your config.inc.php??? :shock:

Good Luck

8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 60 guests