MySQL Database won t start in XAMPP Manager-osx

Question

I downloaded XAMPP about a month ago and it was working just fine  Today I installed a voice recognition software and then restarted my computer  Ever since  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     Starting Apache Web Server     Applications XAMPP xamppfiles apache2 scripts ctl sh   httpd started Starting ProFTPD    Checking syntax of configuration file  Applications XAMPP xamppfiles proftpd scripts ctl sh   proftpd started   Both my ProFTPD and my Apache Web Server are running  MySQL isn t  When I go to phpmyadmin  it throws me this error message    2002 - No such file or directory The server is not responding  or the local server s socket is not correctly configured     Please help me  I have no idea what to do   UPDATE    After looking around the internet a bit  I found a similar problem a user had with MAMP  another user recommended killing the mysql process  what ever that means  Could this be a fix to my problem   UPDATE 2    I found the answer to my problem but I can t answer it yet  So here s the answer   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

User · Answer

For me the following worked  Change permission into  read only  for  everyone  to the file  Applications XAMPP xamppfiles etc my cnf  Then start MySQL from XAMPP manager

User · Answer

Check the   Applications XAMPP xamppfiles var mysql  file s owner   If you see different user and group instead of   mysql       sudo chown -R  mysql  mysql mysql

User · Answer

This could be due to the fact that another instance of mysqd is already running in your mac-book-pro  MacOs-10   It s next to impossible to kill pkill mysqld or       I tried that route many times  with out any success  Finally the following worked for me    launchctl unload -w  Library LaunchDaemons com oracle oss mysql mysqld plist   wait a few minutes and check with   ps -ef grep mysqld   It should be gone

User · Answer

It had the same problem  all I did was give read-only permissions for all users and all items included in the following folders    Applications XAMPP xamppfiles etc  Applications XAMPP xamppfiles sbin

User · Answer

try these two line from terminal   sudo killall mysqld sudo  Applications XAMPP xamppfiles bin mysql server start

User · Answer

If these commands don t work for you        sudo killall mysqld sudo  Applications XAMPP xamppfiles bin mysql server start   Try this    For XAMPP 7 1 1-0  I changed the port number from 3306 to 3307    Click on Manage Servers Select MySQL Database Click on Configure on your right Change your port number to 3307 Click OK Close your Control Panel and relaunch it    You are now good to go

User · Answer

I had success with easy killing all active mysql processes in Monitor Activity tool   1  close XAMPP control  2  open Monitor Activity  3  select filter for All processes  default is My processes   4  search for  mysql  5  force quit all the mysql   6  relaunch XAMPP control and launch apache again  Enjoy

User · Answer

Try this  sudo service mysql stop it will stop any other mysql services and then restart xampp

User · Answer

It had the same problem  all I did was give read-only permissions for ALL users  system included  and all items included in the following folders    Applications XAMPP xamppfiles etc  Applications XAMPP xamppfiles sbin   and relaunch XAMPP control and launch mysql server again or  sudo  Applications XAMPP xamppfiles bin mysql server start

User · Answer

There s been a lot of answer  but I think I found what is causing it  at least for me  It looks like if you put your computer to sleep  or it falls asleep on its own   when it reopens  it tries to open the the mysql process again  At one point I looked at my activity monitor and I had 5 instances running - killing all of them and then starting mysql works

User · Answer

close XAMPP control sudo killall mysqld sudo  Applications XAMPP xamppfiles bin mysql server start

User · Answer

You seem to have found a work-around by killing the process  but make sure you check for free space on your MySQL partition  If your logs or db files are consuming all your drive space  mysqld will not start

User · Answer

maybe table innodb error after u reinstal or copy file db try to repair tbl innodb  if table cant be repair try delete db or table  xamppfiles var mysql your db  or  xamppfiles var mysql your db your table  change permission folder to open folder database  before delete backup ur folder database

User · Answer

On Mac  I checked the mysql error log file at    Applications XAMPP xamppfiles var mysql MyPCName local err   There I found   InnoDB  Error  could not open single-table tablespace file   some db name some table name ibd   After I deleted that  ibd file and then started MySql  it started

User · Answer

it happened to me  and   sudo  Applications XAMPP xamppfiles bin mysql server start   not work for me      so  i reinstall the xampp  then fix it    attention      reinstall the xampp   will not delete mysql data  no need to worry about that

User · Answer

sudo  Applications XAMPP xamppfiles bin mysql server start       This worked for me

User · Answer

I am running XAMPP 5 6 3-0 for OS X Yosemite 10 10 2 and ran into the same issue twice  the first time was with Mavericks  With a bunch of different solutions to the issue with MySQL Database not starting using Manager App I wanted to confirm what had worked for me  The workaround that always worked and forced MySQL to start was by opening Terminal and using   sudo  Applications XAMPP xamppfiles bin mysql server start  I had the Manager App open and started ProFTPD and Apache and then ran the sudo command   The other suggestion by wishap that worked was to locate  Applications XAMPP xamppfiles etc my cnf file and change the permissions for  everyone  to Read only    The other problem I had that seems to be another issue with many solutions is the problem after everything is started then entering localhost which brings me to the xampp splash screen and then nothing  The only thing that worked for me  to at the very least  to access the phpMyAdmin page is by entering localhost phpmyadmin  I hope this helps others reading through a bunch of threads for an answer    Regards   Erik

User · Answer

Well  sometime there is just ERROR  message is shown in mysql comment on terminal   Then  just reinstall  overwrite  XAMPP  then it can be solved

User · Answer

check the err log on your  Applications XAMPP xamppfiles var mysql  with filename like your machine name local err  if you find something like    Attempted to open a previously opened tablespace  Previous tablespace     uses space ID   the following works for me   edit file    Applications XAMPP xamppfiles etc my cnf  find the  mysqld  section  add one line   innodb force recovery   1  then run  sudo  Applications XAMPP bin mysql server start  everything is ok again   and then the last step    edit the my cnf again and remove the line you just added     innodb force recovery   1   and restart mysql again  Otherwise all your tables will be read only

User · Answer

I have same problem and get this error in hostname err in directory  Applications XAMPP xamppfiles var mysql     2016-09-06 15 32 45 140735322399488  Note  Plugin  FEEDBACK  is   disabled  2016-09-06 15 32 45 140735322399488  Note  Heuristic crash   recovery mode 2016-09-06 15 32 45 140735322399488  Note  Please   restart mysqld without --tc-heuristic-recover 2016-09-06 15 32 45   140735322399488  ERROR  Can t init tc log 2016-09-06 15 32 45   140735322399488  ERROR  Aborting      2016-09-06 15 32 48 20004 mysqld safe mysqld from pid file    Applications XAMPP xamppfiles var mysql hostname pid ended   Then I removed tc log and It works fine after restart mysql through manager-osx

User · Answer

I first couldn t manage to kill mysql daemon with the commands posted here  So I remembered my linux times and did the following   I monitored the running processes by running top in one terminal window  Then I killed mysqld via sudo killall mysqld  screw the PID  -    in another and restarted via sudo  Applications XAMPP xamppfiles bin mysql server start

User · Answer

All the answers stated above in relation to changing the port number are in this situation the best way to solve this problem since you need your voice recognition software to coexist with MAMP  However  you must remember that changing this port number is going to affect all you subsequent connections to MySQL  i e  terminal php code phpmyadmin etc   Hence It would be advisable to change the port on which the voice recognition software runs  Hope this was helpful

User · Answer

After trying all possible options  the below trick worked for me    Navigate to  Applications XAMPP xamppfiles etc  and open the files my conf Search for      The MySQL server    mysqld   user   mysql  port 3308   and change the port number     Start the mysql database again

User · Answer

It s because of the firewall settings     Go to system preferences- Security and Privacy Click on Firewall-  Firewall Options If you have Block all incoming connections checked then uncheck it Check automatically allow signed software to receive incoming connections  hit the lock save your settings Open up xampp  go to manage servers  hit start all  and you will be prompted to accept or deny the incoming connection of mysql and ProFTPD   6 Accept the connection

User · Answer

Try running these two commands in the terminal    sudo killall mysqld sudo  Applications XAMPP xamppfiles bin mysql server start

User · Answer

on      macOs High Sierra   if mysql is not getting started from manager- oxs and have tried direct command i e   sudo  Applications XAMPP bin mysql server start   too than  go to path edit       Applications XAMPP xamppfiles etc    find file        my cnf   edit it   under the  mysqld  section  add following line   innodb force recovery   1   after it save and  run or can be done from manager-osx   sudo  Applications XAMPP bin mysql server start   it should start the mysql   once its run you need to again edit the      my cnf   file and remove the line just added  innodb force recovery   1   stop and start mysql again  by command   sudo  Applications XAMPP bin mysql server start    or  by manager-osx   it will be working fine

User · Answer

Minimal Guide  1  sudo killall mysqld  2  manager-osx   start mysql    If that didn t work     sudo  Applications XAMPP xamppfiles bin mysql server start  Google the error       Examples   Error   ERROR  The server quit without updating PID file   Applications XAMPP xamppfiles var mysql  lt computername gt  local pid   My Solution   In  Applications XAMPP xamppfiles etc my cnf change user    lt uid gt  s that  lt uid gt  is uid from id command     id uid        vim  Applications XAMPP xamppfiles etc my cnf

User · Answer

if you are getting this error               ERROR  The server quit without updating PID file    Try this   Go to  Applications XAMPP xamppfiles var mysql   if there is no file with the name Your Username local pid  Your Username should replace with your Mac Username  Create a file with this name  Then try  sudo  Applications XAMPP xamppfiles bin mysql server start       its worked for me

User · Answer

Just Click on Managed Servers Tab in XAMPP MANAGER   Now select MySQL Database  Click on configure on right side   Change port from 3306 to 3307 and it will work

User · Answer

This should work  sudo  Applications XAMPP xamppfiles bin mysql server start

User · Answer

What I did was the following  In XAMPP Control Panel I edited the my ini file of configuration of MySql and changed the port from 3306 to 3307 and it worked  hope it helped   Edit  after you save this changes be sure that the service is off and then restart the service  I had this same problem when I installed MySQL  it s just the port

User · Answer

It can cause because of the software you installed or may be any other software which is using the same port 3306  This 3306 port is used by the Mysql in XAMPP  Similar kind of problem I faced for Apache  I was running skype and trying to run the XAMPP but the skype uses the same port as Apache so it was not working  Then I sign out from skype then the port was free and the apache started  So you should look for the software in you laptop which is blocking or making busy this port  Free that port by closing the software and then run XAMPP and It will work

User · Answer

Restarting the computer  or using the  kill  commands listed above solve the problem  AS for preventing it from happening  I ve found this occurring anytime my computer goes to sleep  The port is obviously kept reserved  and then on wake  mysql tries to reconnect to that port  but can t  This could be your problem also

User · Answer

It might be the possibility that your voice recognition software has a installer of mysql internally and when u installed this software  it has installed mysql too and added it to the service and this mysql service starts once your system starts  So now u r having two mysql servers  one from voice recognition software and second is from XAMPP  that s why killing the previous process  mysql service   solved your problem  But this is not a permanent solution  you have to repeat it every time when ever you start your machine  So better is to find out that mysql server  service  and change its port no  OR change settings so that mysql service should not start when your machine start  but might be your voice recognition software won t work properly   I hope it will help you   Cheers

User · Answer

I encountered this problem just now  I checked log file and found it is caused by the server was not shutdown correctly  So I found this http   rivenlinux info how-to-recover-innodb-corruption-for-mysql  and add a simple configuration  innodb force recovery   1  in  mysqld  in my cnf  Then the problem was solved   The log file is located  Applications XAMPP xamppfiles var mysql and it named accroding to your server name  Just link this XXX-MacBook-Pro local err

[php] MySQL Database won't start in XAMPP Manager-osx

Examples related to php

Examples related to mysql

Examples related to macos

Examples related to xampp