My SQL problem

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

My SQL problem

Postby mistysarah » 15. August 2017 10:08

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
mistysarah
 
Posts: 1
Joined: 15. August 2017 10:01
XAMPP version: 3.2.2
Operating System: windows 10

Re: My SQL problem

Postby Altrea » 15. August 2017 13:11

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
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: 8896
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: My SQL problem

Postby abese17 » 22. August 2017 05:09

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]
abese17
 
Posts: 1
Joined: 22. August 2017 05:01
XAMPP version: 3.2.2
Operating System: Windows 10


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 72 guests