Page 1 of 1

MySQL Port 3306

PostPosted: 18. September 2010 02:25
by davepfz
I am pursuing the error "#2003 - Can't connect to MySQL server on 'localhost' (10061)" and came across some advice to check that MySQL is attached to port 3306. In the XAMPP Control Panel, MySQL is running (set as a service).

When I click on "Port Check", I get
Code: Select all
RESULT
------

Service              Port   Status
==============================================================================
Apache (HTTP)          80   Program: C:\xampp\apache\bin\httpd.exe
Apache (WebDAV)        81   free
Apache (HTTPS)        443   Program: C:\xampp\apache\bin\httpd.exe

MySQL                3306   free

FileZilla (FTP)        21   free
FileZilla (Admin)   14147   free

Mercury (SMTP)         25   free
Mercury (POP3)        110   free
Mercury (IMAP)        143   free
Mercury (HTTP)       2224   free
Mercury (Finger)       79   free
Mercury (PH)          105   free
Mercury (PopPass)     106   free

Tomcat (AJP/1.3)     8009   free
Tomcat (HTTP)        8080   free


This would indicate to me that MySQL has not attached to it's port. In my.ini, I have:
Code: Select all
skip-networking
enable-named-pipe


This is on a WindowsXP system...

What have I overlooked?

Re: MySQL Port 3306

PostPosted: 18. September 2010 10:52
by Nobbie
davepfz wrote:What have I overlooked?


The documentation.

Read about "skip-networking":

http://dev.mysql.com/doc/refman/5.1/en/ ... erver.html

... If the server was started with --skip-networking, it will not accept TCP/IP connections at all....

Re: MySQL Port 3306

PostPosted: 18. September 2010 23:32
by davepfz
Thanks for the pointer. What with sorting out the Linux versus Windows 'stuff', I managed to get it backwards.

Got it working... Thanks.