Can't get mysql.bat to start on Home PC. - Solved

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

Can't get mysql.bat to start on Home PC. - Solved

Postby Tanarif » 26. December 2012 16:01

Edit : Managed to solve this by broswing through the web, but I'll put the solution here in case it helps anyone.
This was primarily a port problem - the ports that apache and mysql use where being used already.
Apache uses port 80, from the error log below (which is found in the mysql/data folder in xampp) I found that mysql uses port 3306.

In my case, skype was using port 80, and mysqld.exe (which I think came from the mysql server I already had installed) was using 3306. For a quick solution - just go task manager and close these down, and then run xampp again.

Just in case anyone's interested, to know how to find which programs running on a part, I followed the comment by the user aleksandar on this website: http://www.knowledgesutra.com/discuss/tflpci-skype-xampp-port-conflict-overcome.html
Essentially,
In RUN command in start menu. Type "cmd" without quotes.
Now enter:
netstat -a -no

then look for adresses thet ends with ":80". For example: 192.192.1.2:80 or 127.1.0.0:80 or 0.0.0.0:80.
Remember the PID number in the line where is adress with ":80".

Now type: tasklist
Find proces that is marked with our PID number.

And then go to task manager and close those.


--
Hi all,

I can run xampp (portable) fine on my laptop and uni machines, but my home PC can't seem to run mysql for some reason. The apache is up and running. I'm using xampp version 1.8.1. The home PC is running Windows XP with service pack 3 installed. I also have the control panel 3 installed. Here's the mysql error log:

Code: Select all
121226 14:30:20 [Note] Plugin 'FEDERATED' is disabled.
121226 14:30:20 InnoDB: The InnoDB memory heap is disabled
121226 14:30:20 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121226 14:30:20 InnoDB: Compressed tables use zlib 1.2.3
121226 14:30:20 InnoDB: Initializing buffer pool, size = 16.0M
121226 14:30:20 InnoDB: Completed initialization of buffer pool
121226 14:30:20 InnoDB: highest supported file format is Barracuda.
121226 14:30:21  InnoDB: Waiting for the background threads to start
121226 14:30:22 InnoDB: 1.1.8 started; log sequence number 1704851
121226 14:30:22 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
121226 14:30:22 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
121226 14:30:22 [Note] Server socket created on IP: '0.0.0.0'.
121226 14:30:22 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
121226 14:30:22 [ERROR] Do you already have another mysqld server running on port: 3306 ?
121226 14:30:22 [ERROR] Aborting
Tanarif
 
Posts: 2
Joined: 26. December 2012 15:40
Operating System: Windows XP

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 127 guests