MySQL(Xampp) will not start in Windows 8.1

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

MySQL(Xampp) will not start in Windows 8.1

Postby ioanna » 18. February 2016 11:39

Hi all,
I have been using Xampp for a few weeks and so far I had no problem in launching MySQL. This time, when I ran Xampp as administrator (as usual), I got this error:
Problem detected!
Port 3306 in use by ""C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" MySQL57"!


I changed the port from 3306 to 3307 in C:\xampp\mysql\bin\my.ini and restarted my computer, but I still get the same error. I found no working solution online, and I would appreciate it if you could help me with this.

This is the log:

11:38:06 [main] Initializing Control Panel
11:38:06 [main] Windows Version: Windows 8.1 64-bit
11:38:06 [main] XAMPP Version: 5.5.30
11:38:06 [main] Control Panel Version: 3.2.2 [ Compiled: Nov 12th 2015 ]
11:38:06 [main] Running with Administrator rights - good!
11:38:06 [main] XAMPP Installation Directory: "c:\xampp\"
11:38:06 [main] Checking for prerequisites
11:38:06 [main] All prerequisites found
11:38:06 [main] Initializing Modules
11:38:06 [mysql] Problem detected!
11:38:06 [mysql] Port 3306 in use by ""C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" MySQL57"!
11:38:06 [mysql] MySQL WILL NOT start without the configured ports free!
11:38:06 [mysql] You need to uninstall/disable/reconfigure the blocking application
11:38:06 [mysql] or reconfigure MySQL and the Control Panel to listen on a different port
11:38:06 [main] The Mercury module is disabled
11:38:06 [main] The Tomcat module is disabled
11:38:06 [main] Starting Check-Timer
11:38:06 [main] Control Panel Ready
11:38:20 [Apache] Attempting to start Apache service...
11:38:23 [Apache] Status change detected: running
11:38:30 [mysql] Problem detected!
11:38:30 [mysql] Port 3306 in use by ""C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" MySQL57"!
11:38:30 [mysql] MySQL WILL NOT start without the configured ports free!
11:38:30 [mysql] You need to uninstall/disable/reconfigure the blocking application
11:38:30 [mysql] or reconfigure MySQL and the Control Panel to listen on a different port
11:38:30 [mysql] Attempting to start MySQL service...
11:38:33 [mysql] Status change detected: running
11:38:38 [mysql] Status change detected: stopped
11:38:38 [mysql] Error: MySQL shutdown unexpectedly.
11:38:38 [mysql] This may be due to a blocked port, missing dependencies,
11:38:38 [mysql] improper privileges, a crash, or a shutdown by another method.
11:38:38 [mysql] Press the Logs button to view error logs and check
11:38:38 [mysql] the Windows Event Viewer for more clues
11:38:38 [mysql] If you need more help, copy and post this
11:38:38 [mysql] entire log window on the forums
ioanna
 
Posts: 4
Joined: 18. February 2016 11:28
Operating System: Windows 8.1

Re: MySQL(Xampp) will not start in Windows 8.1

Postby Nobbie » 18. February 2016 13:27

Obviously, you have installed another MySQL Server into "C:\Program Files\MySQL\MySQL Server 5.7" which now of course collides with the Xampp MySQL Server. Why did you do that? Deinstall this other server again and everything should be fine.
Nobbie
 
Posts: 8779
Joined: 09. March 2008 13:04

Re: MySQL(Xampp) will not start in Windows 8.1

Postby ioanna » 18. February 2016 13:56

I installed the MySQL Server 5.7 along with MySQL Workbench, which I needed to use. Maybe I shouldn't have done it, but if this is the reason, then how/why was it working fine up until today? I am new to MySQL and trying to figure out what is going on. Anyway, I uninstalled MySQL Server 5.7 as you suggested and now I get the following:

13:40:19 [main] Initializing Control Panel
13:40:19 [main] Windows Version: Windows 8.1 64-bit
13:40:19 [main] XAMPP Version: 5.5.30
13:40:19 [main] Control Panel Version: 3.2.2 [ Compiled: Nov 12th 2015 ]
13:40:19 [main] Running with Administrator rights - good!
13:40:19 [main] XAMPP Installation Directory: "c:\xampp\"
13:40:19 [main] Checking for prerequisites
13:45:04 [main] All prerequisites found
13:45:04 [main] Initializing Modules
13:45:04 [Apache] XAMPP Apache Service is already running on port 443
13:45:04 [main] The Mercury module is disabled
13:45:04 [main] The Tomcat module is disabled
13:45:04 [main] Starting Check-Timer
13:45:04 [main] Control Panel Ready
13:45:21 [mysql] Attempting to start MySQL service...
13:45:24 [mysql] Status change detected: running
13:45:30 [mysql] Status change detected: stopped
13:45:30 [mysql] Error: MySQL shutdown unexpectedly.
13:45:30 [mysql] This may be due to a blocked port, missing dependencies,
13:45:30 [mysql] improper privileges, a crash, or a shutdown by another method.
13:45:30 [mysql] Press the Logs button to view error logs and check
13:45:30 [mysql] the Windows Event Viewer for more clues
13:45:30 [mysql] If you need more help, copy and post this
13:45:30 [mysql] entire log window on the forums

Do you have any clue why is this happening? Thanks
ioanna
 
Posts: 4
Joined: 18. February 2016 11:28
Operating System: Windows 8.1

Re: MySQL(Xampp) will not start in Windows 8.1

Postby Altrea » 18. February 2016 20:13

Hi,

Did you change the MySQL port back to 3306?
What dows the mysql_error.log show?

best wishes,
Altrea
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8298
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MySQL(Xampp) will not start in Windows 8.1

Postby ioanna » 19. February 2016 10:40

I did. I tried a lot of things: I followed an advice to remove ibdata from C:\xampp\mysql\data. The error was still there, so I followed a suggestion to uninstall the MySQL Server 5.7 because it collides with the Xampp MySQL Server. But still it was unresolved. Finally, I removed ib_logfile0 and ib_logfile1 from C:\xampp\mysql\data and MySQL in Xampp was running, but I had an other issue: Whenever I logged in to phpmyadmin, I could view the DB that I had created, but not the tables that they consist. Also, I couldn't even create a new database. Every time I try, phpmyadmin just froze.
So, I uninstalled everything and reinstalled them again, and now I see the same error. The mysql_error.log shows:
2016-02-19 10:16:10 a20 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-02-19 10:16:10 2592 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-02-19 10:16:10 2592 [Note] InnoDB: The InnoDB memory heap is disabled
2016-02-19 10:16:10 2592 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-02-19 10:16:10 2592 [Note] InnoDB: Memory barrier is not used
2016-02-19 10:16:10 2592 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-02-19 10:16:14 2592 [Note] InnoDB: Not using CPU crc32 instructions
2016-02-19 10:16:14 2592 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-02-19 10:16:15 2592 [Note] InnoDB: Completed initialization of buffer pool
2016-02-19 10:16:26 2592 [Note] InnoDB: Highest supported file format is Barracuda.
2016-02-19 10:17:10 2592 [Note] InnoDB: 128 rollback segment(s) are active.
2016-02-19 10:17:10 2592 [Note] InnoDB: Waiting for purge to start
2016-02-19 10:17:10 2592 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835047
2016-02-19 10:17:11 4508 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-02-19 10:17:11 2592 [Note] Plugin 'FEEDBACK' is disabled.
2016-02-19 10:17:13 2592 [Note] Server socket created on IP: '::'.
2016-02-19 10:17:13 2592 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-02-19 10:17:13 2592 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-02-19 10:17:13 2592 [ERROR] Aborting

What should I do?
ioanna
 
Posts: 4
Joined: 18. February 2016 11:28
Operating System: Windows 8.1

Re: MySQL(Xampp) will not start in Windows 8.1

Postby ioanna » 19. February 2016 11:33

SOLUTION:

I found a very simple solution after all, without having to edit any my.ini files or installing and uninstalling stuff. Just in case someone else faces with this problem, I just used two commands in cmd:

Code: Select all
netstat -a -t -n -o|grep 3306


Which tells which program uses port 3306. We just want the PID of the program - say it's 2588 - and then type:

Code: Select all
taskkill /pid 2588 /f

I restarted Xampp and it worked.
ioanna
 
Posts: 4
Joined: 18. February 2016 11:28
Operating System: Windows 8.1


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 58 guests