MySQL Port 3306

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

MySQL Port 3306

Postby davepfz » 18. September 2010 02:25

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?
davepfz
 
Posts: 6
Joined: 15. September 2010 21:25

Re: MySQL Port 3306

Postby Nobbie » 18. September 2010 10:52

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....
Nobbie
 
Posts: 13165
Joined: 09. March 2008 13:04

Re: MySQL Port 3306

Postby davepfz » 18. September 2010 23:32

Thanks for the pointer. What with sorting out the Linux versus Windows 'stuff', I managed to get it backwards.

Got it working... Thanks.
davepfz
 
Posts: 6
Joined: 15. September 2010 21:25


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 163 guests