A blog for technology, SEO tips, website development and open source programming.

MySQL Database won’t start in XAMPP Manager-osx

16 36,731

MySQL Database won't start in XAMPP Manager-osx

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...


youtube-subscribe-button

Follow me on Instagram

instagram



MySQL Database won’t start in XAMPP Manager-osx

Steps

1) Open terminal and type

sudo su

and 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

MacBook App Store not working

Reset Macbook Password in macOS Sierra

Error Launching AVD emulator for Android 5.0 on Mac OSX

[/alert]

16 Comments
  1. […] 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 […]

  2. Shirish says

    It says no such process.

    1. Panayiotis Georgiou says

      try again the steps and send me the version of your php and mysql

  3. […] MySQL Database won’t start in XAMPP Manager-osx […]

  4. phuongnd says

    thanks a lot! My issue was solved.

    Cheers!

    1. Panayiotis Georgiou says

      No prob

  5. alvin says

    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.

    1. Admin says

      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

  6. Cris says

    Thank you for the help!

    1. Panayiotis Georgiou says

      No problem

  7. Ken says

    Thank you. This helped alot

    1. Panayiotis Georgiou says

      No problem

  8. Pat Costa says

    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

    1. Admin says

      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.

  9. debby says

    thank you!!! very helpful

    1. Admin says

      No problem!

Leave a Reply

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More