The post will show to fix mysql problem on xampp. MySQL won’t start in my manager-osx application. It doesn’t throw me an in the application log. This is what it says:
Stopping all servers...
Stopping Apache Web Server...
/Applications/XAMPP/xamppfiles/apache2/scripts/ctl.sh : httpd stopped
Stopping ProFTPD...
Checking syntax of configuration file
/Applications/XAMPP/xamppfiles/proftpd/scripts/ctl.sh : proftpd stopped
Restarting all servers...
Starting MySQL Database...
Follow me on Instagram
MySQL Database won’t start in XAMPP Manager-osx
Steps
1) Open terminal and type
sudo suand then put in your password
2) Then type
ps aux | grep mysql(just copy and paste this)
3) You will need to get the process id of mysql. There should be number near the top, something like 739 or 8827
4) Kill the process using
kill -9 {process id}this should look something like this: kill -9 739
5) Restart MySQL in manager-osx
[alert type=white ]
If any of the above don’t work,
This should work:
sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start
[/alert]
[alert type=white ]
Don’t Miss
Heroku error message no Cedar-supported app detected
Flush DNS cache in macOS Sierra
Reset Macbook Password in macOS Sierra
Error Launching AVD emulator for Android 5.0 on Mac OSX
[/alert]
[…] and everything seemed fine, except that I cannot run the database. I have tried everything from here, but it didn’t work. I couldn’t find the ID either, after […]
It says no such process.
try again the steps and send me the version of your php and mysql
[…] MySQL Database won’t start in XAMPP Manager-osx […]
thanks a lot! My issue was solved.
Cheers!
No prob
after i have tested both, the system prompt me this
“Starting MySQL
. ERROR!”
I only able to start MySQL when I’m connected to home wifi but once I disconnected my wifi, MySQL will stop working.
You should check /etc/mysql/my.cnf bind-address variable and make sure to comment it out as well as skip-networking.
#skip-networking
#bind-address
Or bind address to all network interfaces
bind-address = 0.0.0.0
Thank you for the help!
No problem
Thank you. This helped alot
No problem
Hi,
I am also having difficult. XAMPP was working (even when Skype was on) and then suddenly stopped. I tried your solution here and got nowhere.
‘PatCosta$ sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start
Password:
Starting MySQL
……………………………………………………………………………………….. ERROR! The server quit without updating PID file (/Applications/XAMPP/xamppfiles/var/mysql/Patricks-Air.pid).
Patricks-Air:~ PatCosta$ ‘
I’d like to try the other method but am not sure how I find the process ID.
Any help you can suggest would be great.
–Pat
Hello,
You can find the process ID with the following command:
ps aux | grep httpd
ps aux | grep apache2
ps aux | grep mysql
Regards,
P.
thank you!!! very helpful
No problem!