Google Brings me here. The favourite answers don’t help me.
I’ve now solved it, so maybe this will help someone else.
Problem: after UPDATE of XAMPP to a new version I get the message «MySQL WILL NOT start without the configured ports free!».
However, I only have 1 instance of mysqld running.
It seems that the control panel is not as clever as it looks. As far as I can tell, the single instance of mysqld is the new one i’ve just updated to, but running as a ‘service’. The control panel then tries to start it, and instead of realising its already running, It assumes its another service and reports the error.
Probable cause: The uninstaller failed to remove the autostart property from the mysql service, so the new instal picked it up.
Solution:
open the Xammpp Control Panel and click on the Services Button on the right. This will open the services control panel.
Look for mysqld in the list of running processes, right-click it to get the properties and change the startup type to «Manual».
you might as well do the same for Apache2 while you’re here.
Apply changes and Close the services control panel.
Now click the Config Button on xampp control panel, uncheck The Mysql (and Apache) Autostart features.
Reboot the machine.
You should now be able to start / stop Mysql & Apache without any error messages.
If this works, use the Xampp Control panel as usual to start/stop add service or add autostart as normal.
No need to mess with any ports or config files.
Google Brings me here. The favourite answers don’t help me.
I’ve now solved it, so maybe this will help someone else.
Problem: after UPDATE of XAMPP to a new version I get the message «MySQL WILL NOT start without the configured ports free!».
However, I only have 1 instance of mysqld running.
It seems that the control panel is not as clever as it looks. As far as I can tell, the single instance of mysqld is the new one i’ve just updated to, but running as a ‘service’. The control panel then tries to start it, and instead of realising its already running, It assumes its another service and reports the error.
Probable cause: The uninstaller failed to remove the autostart property from the mysql service, so the new instal picked it up.
Solution:
open the Xammpp Control Panel and click on the Services Button on the right. This will open the services control panel.
Look for mysqld in the list of running processes, right-click it to get the properties and change the startup type to «Manual».
you might as well do the same for Apache2 while you’re here.
Apply changes and Close the services control panel.
Now click the Config Button on xampp control panel, uncheck The Mysql (and Apache) Autostart features.
Reboot the machine.
You should now be able to start / stop Mysql & Apache without any error messages.
If this works, use the Xampp Control panel as usual to start/stop add service or add autostart as normal.
No need to mess with any ports or config files.
Google Brings me here. The favourite answers don’t help me.
I’ve now solved it, so maybe this will help someone else.
Problem: after UPDATE of XAMPP to a new version I get the message «MySQL WILL NOT start without the configured ports free!».
However, I only have 1 instance of mysqld running.
It seems that the control panel is not as clever as it looks. As far as I can tell, the single instance of mysqld is the new one i’ve just updated to, but running as a ‘service’. The control panel then tries to start it, and instead of realising its already running, It assumes its another service and reports the error.
Probable cause: The uninstaller failed to remove the autostart property from the mysql service, so the new instal picked it up.
Solution:
open the Xammpp Control Panel and click on the Services Button on the right. This will open the services control panel.
Look for mysqld in the list of running processes, right-click it to get the properties and change the startup type to «Manual».
you might as well do the same for Apache2 while you’re here.
Apply changes and Close the services control panel.
Now click the Config Button on xampp control panel, uncheck The Mysql (and Apache) Autostart features.
Reboot the machine.
You should now be able to start / stop Mysql & Apache without any error messages.
If this works, use the Xampp Control panel as usual to start/stop add service or add autostart as normal.
No need to mess with any ports or config files.
Slide 1
Most trusted JOB oriented professional program
DevOps Certified Professional (DCP)
Take your first step into the world of DevOps with this course, which will help you to learn about the methodologies and tools used to develop, deploy, and operate high-quality software.
Slide 2
DevOps to DevSecOps – Learn the evolution
DevSecOps Certified Professional (DSOCP)
Learn to automate security into a fast-paced DevOps environment using various open-source tools and scripts.
Slide 2
Get certified in the new tech skill to rule the industry
Site Reliability Engineering (SRE) Certified Professional
A method of measuring and achieving reliability through engineering and operations work – developed by Google to manage services.
Slide 2
Master in DevOps Engineering (MDE)
Get enrolled for the most advanced and only course in the WORLD which can make you an expert and proficient Architect in DevOps, DevSecOps and Site Reliability Engineering (SRE) principles together.
Slide 2
Gain expertise and certified yourself
Azure DevOps Solutions Expert
Learn about the DevOps services available on Azure and how you can use them to make your workflow more efficient.
Slide 3
AWS Certified DevOps Professional
Learn about the DevOps services offered by AWS and how you can use them to make your workflow more efficient.
When I open XAMPP and click start MySQL button and it gives me an error. I had started it just before, but now it isn’t working.
12:19:12 PM [mysql] Attempting to start MySQL app... 12:19:12 PM [mysql] Status change detected: running 12:19:13 PM [mysql] Status change detected: stopped 12:19:13 PM [mysql] Error: MySQL shutdown unexpectedly. 12:19:13 PM [mysql] This may be due to a blocked port, missing dependencies, 12:19:13 PM [mysql] improper privileges, a crash, or a shutdown by another method 12:19:13 PM [mysql] Press the Logs button to view error logs and check 12:19:13 PM [mysql] the Windows Event Viewer for more clues 12:19:13 PM [mysql] If you need more help, copy and post this 12:19:13 PM [mysql] entire log window on the forums
Answer
Stop there! Please do not delete anything!
Some of the answers in Stackoverflow or in other platform could leave completely unusable your database!, so, before deleting files, first try to do what the error message in XAMPP message panel recommend you to do, using the MySQL backup folder which is included with XAMPP. So do the next:
Step 1. Rename the folder c:xamppmysqldata to c:xamppmysqldata_old (you can use any name).
Step 2. Create a new folder c:xamppmysql/data.
Step 3. Copy the content that resides in mysqlbackup to the new mysqldata folder.
Step 4. Copy all your database folders that are in mysqldata_old to mysqldata (skipping the mysql, performance_schema, and phpmyadmin folders from data_old).
Step 5. Finally copy the ibdata1 file from mysqldata_old and replace it inside mysqldata folder.
Step 6. Start MySQL from XAMPP control panel.
And, Its DONE . No databases lost, no ports changed, no run as administrator, no force recovery, no kill mysqld process, no restoring from previous versions, no more errors.
Thanks for Reading.
keep Coding.
- Author
- Recent Posts
Email:- contact@DevOpsSchool.com
I am using Ubuntu 14.04 and Xampp 5.6.3-0. I cannot get the MySQL server to run. I have tried executing these commands so far (run in this order):
sudo chmod 755 /opt/lampp/etc/my.cnf
sudo chmod -R 777 /opt/lampp/var/mysql
sudo chown -hR root/opt/lampp
This produced: chown: missing operand after ‘root/opt/lampp’
sudo chown -hR root:root /opt/lampp
sudo chmod 755 /opt/lampp/etc/my.cnf
sudo chmod 777 /opt/lampp/var/mysql -R
sudo /opt/lampp/lampp restart
Which produced: (running this commend twice in a row produces the same result)
Restarting XAMPP for Linux 5.6.3-0...
XAMPP: Stopping Apache...ok.
XAMPP: Stopping MySQL...not running.
XAMPP: Stopping ProFTPD...ok.
XAMPP: Starting Apache...ok.
XAMPP: Starting MySQL...ok.
XAMPP: Starting ProFTPD...ok.
But the server will still not start after this, how do I get the server to start?
Edit:
$ sudo lsof -i TCP:3306
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
mysqld 1222 mysql 10u IPv4 10907 0t0 TCP localhost:mysql (LISTEN)`
and
$ sudo /etc/init.d/mysql status
* /usr/bin/mysqladmin Ver 8.42 Distrib 5.5.40, for debian-linux-gnu on x86_64
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Server version 5.5.40-0ubuntu0.14.04.1
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 1 day 4 hours 35 min 35 sec
With all this when trying to connect to phpmyadmin I get: 