Apache Friends Support Forum

Hi,I am trying to access MySQL in Xampp, I have received the following error message:
10:07:19 [main] Initializing Control Panel
10:07:19 [main] Windows Version: Pro 64-bit
10:07:19 [main] XAMPP Version: 7.1.7
10:07:19 [main] Control Panel Version: 3.2.2 [ Compiled: Nov 12th 2015 ]
10:07:19 [main] You are not running with administrator rights! This will work for
10:07:19 [main] most application stuff but whenever you do something with services
10:07:19 [main] there will be a security dialogue or things will break! So think
10:07:19 [main] about running this application with administrator rights!
10:07:19 [main] XAMPP Installation Directory: "c:\xampp1\"
10:07:20 [main] Checking for prerequisites
10:07:20 [main] All prerequisites found
10:07:20 [main] Initializing Modules
10:07:20 [mysql] Problem detected!
10:07:20 [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"!
10:07:20 [mysql] MySQL WILL NOT start without the configured ports free!
10:07:20 [mysql] You need to uninstall/disable/reconfigure the blocking application
10:07:20 [mysql] or reconfigure MySQL and the Control Panel to listen on a different port
10:07:20 [main] Starting Check-Timer
10:07:20 [main] Control Panel Ready
10:08:08 [Apache] Attempting to start Apache app...
10:08:08 [Apache] Status change detected: running
10:08:23 [mysql] Problem detected!
10:08:23 [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"!
10:08:23 [mysql] MySQL WILL NOT start without the configured ports free!
10:08:23 [mysql] You need to uninstall/disable/reconfigure the blocking application
10:08:23 [mysql] or reconfigure MySQL and the Control Panel to listen on a different port
10:08:23 [mysql] Attempting to start MySQL app...
10:08:24 [mysql] Status change detected: running
10:08:27 [mysql] Status change detected: stopped
10:08:27 [mysql] Error: MySQL shutdown unexpectedly.
10:08:27 [mysql] This may be due to a blocked port, missing dependencies,
10:08:27 [mysql] improper privileges, a crash, or a shutdown by another method.
10:08:27 [mysql] Press the Logs button to view error logs and check
10:08:27 [mysql] the Windows Event Viewer for more clues
10:08:27 [mysql] If you need more help, copy and post this
10:08:27 [mysql] entire log window on the forums
Can anyone help me please Thank you in advance

Hi,

mistysarah wrote:10:07:20 [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"!

You did already install a standalone version of MySQL which is running and occupying the port XAMPP MySQL needs.
You should stop/uninstall the other MySQL Server if you don't need it.

best wishes,
Altrea

Hi,
I encountered similar problem recently :

12:08:14 PM [main] Initializing Control Panel
12:08:14 PM [main] Windows Version: Home 64-bit
12:08:14 PM [main] XAMPP Version: 7.1.4
12:08:14 PM [main] Control Panel Version: 3.2.2 [ Compiled: Nov 12th 2015 ]
12:08:14 PM [main] You are not running with administrator rights! This will work for
12:08:14 PM [main] most application stuff but whenever you do something with services
12:08:14 PM [main] there will be a security dialogue or things will break! So think
12:08:14 PM [main] about running this application with administrator rights!
12:08:14 PM [main] XAMPP Installation Directory: "c:\xamppp\"
12:08:14 PM [main] Checking for prerequisites
12:08:14 PM [main] All prerequisites found
12:08:14 PM [main] Initializing Modules
12:08:14 PM [main] Starting Check-Timer
12:08:14 PM [main] Control Panel Ready
12:08:20 PM [Apache] Attempting to start Apache app...
12:08:20 PM [Apache] Status change detected: running
12:08:27 PM [mysql] Attempting to start MySQL app...
12:08:27 PM [mysql] Status change detected: running
12:08:58 PM [mysql] Status change detected: stopped
12:08:58 PM [mysql] Error: MySQL shutdown unexpectedly.
12:08:58 PM [mysql] This may be due to a blocked port, missing dependencies,
12:08:58 PM [mysql] improper privileges, a crash, or a shutdown by another method.
12:08:58 PM [mysql] Press the Logs button to view error logs and check
12:08:58 PM [mysql] the Windows Event Viewer for more clues
12:08:58 PM [mysql] If you need more help, copy and post this
12:08:58 PM [mysql] entire log window on the forums
12:13:51 PM [mysql] Attempting to start MySQL app...
12:13:51 PM [mysql] Status change detected: running

It happened quite frequently until I found that this is because the folder name inside mysql/data/{folder_name} which I created manually by copying from old folder.
The problem totally gone after I deleted those folders with all the contents and decided to create the folder@database within phpmyadmin.. crying..

[just for sharing]