Juan Aldasoro

MySQL server not Starting, a usual MAMP headache

Written by

Juanfra

in

,

As many others WordPress developers out there, I use MAMP for local development.

I like the fact that is the faster and easier way to setup a low-maintenance development envi­ron­ment for OSX. Personally, I love setting up and using virtual hosts & WordPress multisite. That way I can work with loads of different projects in an organized manner.

The only problem I often get with this platform, is that MySQL won’t start. I hate when I resume my computer after sleeping a few hours, and I get that annoying red light just beside “MySQL server” indicator. Sometimes, it also happens when restarting your computer. And there it is, MySQL not starting.

There’s an easy solution for this, a quick and tiny fix you can run as many times you need. Simply killing all MySQL processes and then starting the servers again. Assuming that not many people hosts websites on OSX, you won’t have any collateral damage.

All you need to do, is run a simple command on the terminal or hyper.

killall -9 mysqld

This command will kill off the process. Then you’ll be able to start again your servers by hitting “Start Servers” in the MAMP app.

Note: Terminal is the terminal emulator included in Apple’s OS X operating system. You can find that app under Applications/Utilities. It’s basically a UNIX Shell. You can check if there are any MySQL processes running the “top” command. You can also use Hyper, a terminal app built by the amazing @rauchg and team.

Update – January 2017

If you are having trouble fixing this issue with the instructions above, many readers are being able to solve this problem thanks to the amazing fix shared by one of the commenters, ElCid. The instructions he shared are the following:

  1. Quit MAMP.
  2. In the finder go to Applications/MAMP/db/mysql/ and delete the last log file (look for a file named ib_logfileN – being N the log number). Please back up these before you delete them 🙂
  3. Restart MAMP.
  4. That’s it!

Comments

147 responses to “MySQL server not Starting, a usual MAMP headache”

  1. Xavier Kreiss Avatar
    Xavier Kreiss

    Hi

    Trying to use Mysql for the first time – “start servers” causes a grey spinning wheel to spin for about a second in the Mysql window, then nothing. And yet it says the Mysql server is “on” (green button). I don’t understand.

    The Terminal command “killall -9 mysqld” doesn’t work – it just gives the answer unknown-d4:9a:20:06:10:3a:~ xavierkreiss$

    I’m going mad.

    BTW I’ve uninstalled MAMP and reinstalled it – still no joy.

    Best wishes

    Xavier

    Reply
    1. Juanfra Avatar
      Juanfra

      Hi Xavier,

      Thanks for writing. It sounds like mysql is not installed correctly through MAMP, or it is not starting. Is your MAMP phpmyadmin working?

      Best,
      Juanfra.

      Reply
      1. Xavier Kreiss Avatar
        Xavier Kreiss

        Hi Juanfra

        Thanks for your answer. I’m proud to say that after deleting MAMP, reinstalling it,and re-launching it, I managed to make it work. And I’ve been able to understand a little about how both mysql and php work. But I haven’t been able to install Joomla properly, which is what I was trying to do. It’s definitely not for “non-techies” like me.

        But learning about MAMP has, at least, taught me something new, which might one day come in useful.

        Thanks again

        Xavier

        Reply
        1. Juanfra Avatar
          Juanfra

          Hi Xavier,

          I’m happy to hear that 🙂 – I always recommend WordPress on top of others like Joomla or Drupal. You can download a copy from http://wordpress.org and have your site running in a few minutes. You can check more about installing WordPress here: http://codex.wordpress.org/Installing_WordPress

          Best,
          Juanfra.

          Reply
        2. Jon Buckner Avatar
          Jon Buckner

          Hi Xavier

          I recently got Joomla working with MAMP

          The problem is due to a bug in Joomla.

          You have to change a bit of code form ‘true’ to ‘false’

          http://www.ostraining.com/support-forum/joomla-support/mamp-jommla-3-1-5-php-5-5-making-it-work/

          Though I realise this reply is a long time after your comment, I hope you have it working, so this is more for other people

          Excellent article JUANFRA

          Thanks very much

          Reply
          1. Juanfra Avatar
            Juanfra

            Hey Jon,

            Thanks for sharing your experience, and thanks for your kind words 🙂

  2. Braindead Avatar
    Braindead

    You saved my hide today. Thanks!

    Reply
    1. Juanfra Avatar
      Juanfra

      No worries 🙂

      Reply
  3. Chris Avatar
    Chris

    This worked. I had absolutely no idea – I thought I was going to have to reinstall or something. Thanks so much, Juanfra!

    Reply
    1. Juanfra Avatar
      Juanfra

      No problem 🙂 Neither did I at first, and I had the same sensation! lol

      Reply
  4. kimmm Avatar
    kimmm

    Worked! Thank you Jaunfra!

    Reply
  5. Jenny Harle Avatar
    Jenny Harle

    Thanks! This post saved me a headache.

    Reply
  6. Shovan Sargunam Avatar
    Shovan Sargunam

    Hi

    I tried it this is what I get

    No matching processes belonging to you were found

    Any suggestion?

    Reply
    1. Juanfra Avatar
      Juanfra

      Hi Shovan,

      If it’s not your process, prepend sudo in order to run the command as administrator. That would be:

      sudo killall -9 mysqld

      It will ask for the administrator password. If you’re not the administrator, you may be out of luck 🙁

      Good luck,
      Juanfra.

      Reply
  7. Will Cabral Avatar
    Will Cabral

    Hey Juanfra, I’m getting the same issue as Shovan. I tried the “sudo killall -9 mysqld” command, entered my password and it still returned “No matching processes belonging to you were found”

    Any other possible suggestions?

    I did just update my mamp yesterday and ever since then MySQL hasn’t been back online so that has to be part/all of the issue.

    Thanks!

    Reply
  8. Will Cabral Avatar
    Will Cabral

    After some more research I found that apparently there are issues with Mac 10.8.3 and the newer version of MAMP running correctly. I’m guessing that’s the same issue Shovan is having. I went back to the MAMP site and downloaded the older MAMP (1.9.6.1) and everything worked perfectly again.

    Reply
    1. Juanfra Avatar
      Juanfra

      Thanks for sharing, Will 🙂

      Reply
  9. kimmm Avatar
    kimmm

    Thank you for sharing this tip Juanfra! I have used it several times and it’s worked without fail.

    Reply
  10. Ereeek Avatar
    Ereeek

    Mahalos for this! Back to work!

    Reply
  11. Justin Avatar
    Justin

    Thanks, it’s totally worked for me.

    Reply
  12. Ben Avatar
    Ben

    Juan you are the man. Thanks for this quick tip.

    Reply
  13. Kim Avatar
    Kim

    Thanks for the tip! Worked great

    Reply
  14. Georgia Gibbs Avatar
    Georgia Gibbs

    I just wanted to thank you for posting this. You saved me from a lot of frustration!

    Reply
  15. Simon Avatar
    Simon

    Thanks saved me hours.

    Reply
  16. Joe Avatar
    Joe

    So simple, yet so many people with this issue out there. Thanks! Keep it up

    Reply
  17. Albin Avatar
    Albin

    Thanks! =B

    Reply
  18. joey Avatar
    joey

    very helpful, thank you!

    Reply
  19. Michael Avatar
    Michael

    THANKS! I was looking all over the place for just this.

    Reply
  20. Usman Avatar
    Usman

    great solution. thanks

    Reply
  21. Monika Avatar
    Monika

    Great – thanks!

    Reply
  22. Gabriel Avatar
    Gabriel

    You’re fucking awesome!

    Worked great!

    Thanks!

    Reply
  23. Schurpf Avatar
    Schurpf

    Thanks! Just worked 🙂

    Reply
  24. Ann Avatar
    Ann

    thank you–it worked for me too.

    Reply
  25. theclaw Avatar
    theclaw

    Great fix, worked like a charm for me !

    Thanks a lot

    Reply
  26. Richard Deans Avatar
    Richard Deans

    Hi all, the solution is great but there are a few occasions where bizarrely even using SUDO will not close the process in terminal. I have no idea why this is however… If you do a search for ‘activity monitor’ and locate the mysqlld process and kill it that way you will then be able to resolve the issue. Truly hope that this helps anyone who is currently banging there head against the wall.

    Laters

    Regards

    Richard

    Reply
    1. Juanfra Avatar
      Juanfra

      That’s really strange. SUDO should be killing the process.

      Another option would be checking the process id with top, ps or some other command and later kill the process with the process id as an argument.

      Thanks for writing!
      Cheers

      Reply
  27. Víctor M. Martinez Valero Avatar
    Víctor M. Martinez Valero

    This worked marvels for me too Juanfra, thank you for this post!

    Reply
  28. Naser Avatar
    Naser

    Works great for me too!

    Thanks a lot!

    Reply
  29. Kelly Avatar
    Kelly

    Thanks! Bookmarking this for next time.

    Reply
  30. Peaceedotcom Avatar
    Peaceedotcom

    Thank you for this. it resolved it. But now most of my website is not showing. i see error messages like “Error displaying the error page: Application Instantiation Error”.
    Consequently i had upgraded y MAMP app before viewing my sites. Could the new MAMP be the problem. Few of my sites are view normally though. Any help?

    Reply
    1. Juanfra Avatar
      Juanfra

      Thanks for writing. Well, it depends on the application that you’re using to run your website. The information on this post only does the trick when the mysql services is not starting.

      Reply
  31. Jay Avatar
    Jay

    im a total newbie at all of this and your terminal command just save me hours of trying to figure out what i did wrong, thanks a million!

    Reply
  32. Ravi Avatar
    Ravi

    Thanks, it worked like a charm – running Mavericks on MacBook Pro 212

    Reply
  33. Angel Avatar
    Angel

    This was perfect, thank you! 🙂

    Reply
  34. Philip Harper Avatar
    Philip Harper

    Nifty trick,

    nice one!

    Reply
  35. Rob Nichols Avatar
    Rob Nichols

    Cheers 😀

    Reply
  36. William Sipling Avatar
    William Sipling

    You sir, are the best. Thanks for posting this last year, it was helpful to me today!

    Reply
  37. dave Avatar
    dave

    I can’t write when password comes up. Do I put the whole thing in Textwrangler or something like that?
    dave

    Reply
    1. Juanfra Avatar
      Juanfra

      Hello Dave,

      The whole idea is that the console asks for your password in order to execute the command. If the password is OK, then the command will be executed. Else, you should see an error message.

      Cheers.

      Reply
  38. bloohair Avatar
    bloohair

    Thank you SO much Juanfra – one very scary moment then with no access to about 20 websites. I can only assume that I accidentally put the wrong password into MAMP and that crashed it.

    Reply
  39. Graylien Avatar
    Graylien

    Thank you! 😀

    Reply
  40. Alicia St Rose Avatar
    Alicia St Rose

    Thank you Jaunfra! This worked spendidly. You are my internet hero today!

    Reply
    1. Juanfra Avatar
      Juanfra

      haha, no problem 🙂

      Reply
  41. Rafael Trabasso Avatar
    Rafael Trabasso

    Saved me today. MAMP was locked after I updated Mac OS X.

    Thanks a lot and warm cheers from Brazil.

    Reply
    1. Juanfra Avatar
      Juanfra

      Obrigado Rafael! Abraço

      Reply
  42. RJ Avatar
    RJ

    Thank you very much! This worked perfectly!

    Reply
  43. Quynh Avatar
    Quynh

    Hi Juanfra,

    I tried many solutions to the “mySQL Server not starting” but can’t get it back and now I can’t access to more than 10 websites on my Mac.
    When I type “sudo killall – 9 myslqd, it said “No matching process belonging to you were found”.

    Really appreciate if you can help! 🙁

    Reply
    1. Juanfra Avatar
      Juanfra

      Hi Quynh,
      Please check that you have a blank space between the dash and the 9, it should be `sudo killall -9 mysqld`

      Reply
  44. Kristin Avatar
    Kristin

    Amazing. Thank you!

    Reply
  45. Cheri Schappaugh Avatar
    Cheri Schappaugh

    Thank you this worked for OS X El Capitan update to version: 10.11.16.
    Many Thanks!!

    Reply
  46. jude Avatar
    jude

    Yessssssss!!!!!! I’ve been fighting with this for 3 hours.

    Reply
  47. Don Avatar
    Don

    Hi,
    I have tried this(kiil all- terminal thing) but it shows ”No matching processes belonging to you were found”.
    I cant seem to start it any other way please help ,
    i tried deleting the files in the MAMP/db/mysql folder …mysql server starts after that but it shows me wordpress instalation page after that

    Reply
    1. Juanfra Avatar
      Juanfra

      Please have in mind that you need to be literal with console commands. You quoted that you did the `kiil all- terminal thing`, when you had to type `killall -9 mysqld`. Now, erasing the whole mysql folder on your MAMP installation is a dangerous thing to do. For your specific case I’d reinstall MAMP, you might have lost a lot of configuration files + databases.

      Reply
  48. marioamin Avatar
    marioamin

    Marios-iMac:~ marioamin$ killall -9 mysqld
    No matching processes belonging to you were found

    same here, thats what iam getting

    Reply
    1. Juanfra Avatar
      Juanfra

      Have you tried with sudo? `sudo killall -9 mysqld`?

      If you get the same response check if there’s any mysql process at all with top (or vtop if you want, you’ll need to install it, but it feels and looks so much better).

      Cheers!

      Reply
  49. ElCid Avatar
    ElCid

    Thank you for sharing your solution. Although it didn’t work for me, I explored a bit and something even easier did the job:
    1-Quit MAMP. 2- In the finder go to Applications/MAMP/db/mysql56/ and delete the last log file (in my case ib_logfile1). 3-Restart MAMP. Don’t ask me why but this solved the issue and now MySQL server is working! I hope this is helpful to others. Cheers.

    Reply
    1. Juliana Avatar
      Juliana

      Wow thank you so much for this! I had tried all of the commands on the terminal and nothing solved it but this! (in my case it was ib_logfile0). PS I am running OS X El Capitan 10.11.6 and my SSD is not even nearly full.

      Reply
      1. Zedity Avatar
        Zedity

        Deleting the ib_logfile(s) solved the problem also on Sierra 10.12.2.
        Thanks

        Reply
        1. Angela Avatar
          Angela

          Hi I also had to delete both of the log files but then it worked. Amazing tip! Thanks so much!!

          Reply
    2. C.E Avatar
      C.E

      This also worked for me. Thank you very much!!

      Reply
    3. Studio 108 Avatar
      Studio 108

      WOW a big thank you!! Deleting the ib_logfile1 file worked for me also.

      Reply
    4. Iris Avatar
      Iris

      OMG THANK YOU this worked for me.
      I tried almost everything else under the sun, the mysql server did not want to start even though I did not have it running (couldn’t find any processes), I reinstalled MAMP and tried a bunch of other things people recommended, all to no avail, until; your suggestion!
      Thank you Thank you Thank you

      Reply
    5. Bradley Avatar
      Bradley

      Yes this was the only thing that worked for me also. I had to delete both 0 and 1. Thanks man I appreciate it!

      Reply
    6. chapu Avatar
      chapu

      this worked for me thanks!!(in my case i deleted 2 files ib_logfile1, ib_logfile0)

      Reply
    7. Lina Avatar
      Lina

      ElCid,
      Thank you so much!!! After fighting this all evening, and trying everything but reinstall… Your solution worked! 😀

      Reply
    8. Rob Avatar
      Rob

      This worked for me. THANK YOU!

      Reply
    9. Guillaume Avatar
      Guillaume

      Hi ! I tried to do so and yes, MySQL started to work again.
      BUT ! All my database tables seem to be empty when I look in PHPMyAdmin ! So when I try to launch my WordPress websites, it asks me to install WordPress, assuming the site is empty… Any idea how to get my databases back ? Thanks in advance for your help !

      Reply
    10. Marcello Avatar
      Marcello

      nice one!

      Reply
    11. mai Avatar
      mai

      Hi, thank you, this way solved the my issue here, too. MAMP started again. it seems very simple and reasonable way.

      Reply
  50. ElCid Avatar
    ElCid

    Forgot to say that I am running OS X Yosemite 10.10.5 on a MacBook Pro with an almost full SSD. Probably it was because of my lack of disk space that the log file got corrupted.

    Reply
    1. Juanfra Avatar
      Juanfra

      Thanks for sharing! Cheers.

      Reply
      1. Kuenzang Avatar
        Kuenzang

        I have tried any possible methods to start the MySQL server in mamp on my MacBook Air OX 10.10 Yosemite. Nothing happens…I deleted the log files in MySQL56 and restarted…nothing happens…what is the problem? M almost giving up on mamp..☹️☹️☹️

        Reply
        1. Juanfra Avatar
          Juanfra

          Sorry to hear that! What files are the ones you erased? If you go to phpmyadmin do you get to see the db and table structures?

          Reply
  51. nathan Avatar
    nathan

    You truly are a legend it worked. I went on my christmas holiday, i came back today and my deadline is tomorrow ive been all over stack overflow and other sites.

    Thanks for the help mate.

    Reply
  52. MySQL server not Starting with MAMP – See Spot Run – Web Development and SEO in Vancouver

    […] the World Wide Web as I would, I came across a great article from Juanfra Aldasoro from Argentina on how to use terminal to quit any MySQL processes from running to get the server to reboot. […]

    Reply
  53. Eduardo Oliveira Avatar
    Eduardo Oliveira

    Thank you! It worked! Great tip.

    Reply
  54. Dolly\ Avatar
    Dolly\

    Life saver!!!!

    Reply
  55. Daniel Avatar
    Daniel

    Thanks for the update. This worked like a charm. You ROCK!!!!!!!!!!!!!

    Reply
  56. Dave Avatar
    Dave

    Thank you so much!!!!!

    Reply
  57. Mimi Avatar
    Mimi

    Tanks a million!

    Reply
  58. john dow Avatar
    john dow

    Your post worked for me…”Quit MAMP. In the finder go to Applications/MAMP/db/mysql/ and delete the last log file (look for a file named ib_logfileN – being N the log number). Please back up these before you delete them
    Restart MAMP.”

    My Situation immediately prior to problem. Think my power cable to laptop shorted and computer shut down instantly. upon restart the sql server on MAMP did not register or start. Clearing the log file worked.

    Thanks

    Reply
  59. Anu Avatar
    Anu

    Thank you so much! 🙂

    Reply
  60. Lucas Avatar
    Lucas

    Woks perfectly, thanks!

    Reply
  61. Ashok G Avatar
    Ashok G

    Thanks Alsasoro. It worked with a charm. 🙂

    Reply
  62. Frederick Avatar
    Frederick

    Thank you for the help!

    Reply
  63. Nassor Avatar
    Nassor

    Thank you soooo much

    Reply
  64. Milo Avatar
    Milo

    Thank you millions! The updated version worked for me. Sooo simple and easy. I had to restart the whole computer, though, restarting MAMP was not enough.

    Reply
  65. Patrick Avatar
    Patrick

    Firstly thanks for post!

    I just want to add that moving the ib_logfile* and auto.cnf elsewhere did not work for me even after restarting the computer. But moving the ibdata1 file elsewhere worked and by that I mean now MAMP can start MySQL server.

    However when I visit the wordpress site I had installed, I am prompted to reinstall WP.

    My environment: macOS Sierra 10.12.3, MAMP 4.1 (454), MySQL 5.6.34, Apache 2.4.23, PHP 7.10

    Reply
    1. Mairead Avatar
      Mairead

      Hi Patrick, I’m having the same issue. Did you find a solution?

      Reply
  66. Denise Avatar
    Denise

    Thank you for the help!

    Reply
  67. Danny Avatar
    Danny

    Hi, that’s work!!!! thx.

    Reply
  68. Mark Avatar
    Mark

    Thanks for the fix!

    Reply
  69. ethiopians Avatar
    ethiopians

    Thanks so much, deleting the ib_logfile worked for me.

    Reply
  70. Katelyn Avatar
    Katelyn

    Thank you! deleting the ib_logfile worked.

    Reply
  71. Rakhi Avatar
    Rakhi

    Great tip. Thank you so much.

    Reply
  72. Peter Avatar
    Peter

    Thanks, this solution worked! Solved me hours of research!

    Reply
  73. David Pire Hernandez Avatar
    David Pire Hernandez

    perfect thankss was worry i am new with macos jejeje delete the files log 0 y log 1 those two files and it works!!!

    Reply
  74. OS X update causes MAMP MySQL server to not start – Mark Carlson

    […] h/t (https://juanfra.me/2013/01/mysql-not-starting-mamp-fix/) […]

    Reply
  75. Nicole Rhoads Avatar
    Nicole Rhoads

    Just wanted to say this worked for me today on Mamp 4.2 and OS Sierra. Thank you!!!

    Reply
  76. Jusang You Avatar
    Jusang You

    wowowowo…You really saved my life.

    Reply
  77. Brian Avatar
    Brian

    Thanks for this fix! Just a note for MAMP PRO users: I had to go to a different folder to find those logs files. For me they were located at Library/Application Support/appsolute/MAMP PRO/db/mysql56 . Once I found them and deleted both (0 and 1) – I was able to start SQL again.

    Reply
    1. dan Avatar
      dan

      Thanks it was this exact update that broke me. Brian your comment narrowed it for me. Thanks bud.

      Reply
    2. Juan Encalada Avatar
      Juan Encalada

      Thank you Brian! This worked for me! I kept deleting the files from the MAMP folder in Applications but I guess since I’m using MAMP Pro now it wasn’t enough.

      Thanks again!

      Reply
      1. SKY1 - Livermore Web Design Avatar
        SKY1 – Livermore Web Design

        Thanks, this is what I was missing the whole time. I’m on MAMP Pro

        Tried all the other methods above for over an hour. Finally found your comment.

        Much appreciated!

        Reply
  78. Faith Avatar
    Faith

    I deleted the last log file ib_logfile0 and keep ib_logfile1 there . Then I was able to start phymyadmin. however, i was not able to connect to My Website.
    Error: localhost is currently unable to handle this request.
    HTTP ERROR 500.

    Do you have any suggestions?

    if there a way we can open the ib_logfile0 and read it?. why remove the last log file ib_logfile could fix phpmyadmin not start problem? Is there a way we can manually fix the bad data in ib_logfile?

    Reply
    1. Faith Avatar
      Faith

      I changed the php version back to 5.6.27, then My Website was working.

      Thanks for the post. It save me hours!

      Reply
  79. Kelvin Avatar
    Kelvin

    Thank you guy, it worked like magic… I really Appreciate

    Reply
  80. Nikita Avatar
    Nikita

    ‘Update – January 2017’ solution helped in my case. Thanks a lot!

    Reply
  81. Catherine Pedersen Avatar
    Catherine Pedersen

    Killing all MYSQL processes worked! Thank you for your article. Very helpful Juanfra!

    Reply
  82. Chatman Avatar
    Chatman

    Thanks for the tip!

    Reply
  83. prakash Muniyappa Avatar
    prakash Muniyappa

    ‘Update – January 2017’ solution worked for me. Thanks a lot to you and ElCid!

    Reply
  84. Jon Avatar
    Jon

    Thank you so much. That fix from El CId fixed it for me!

    Reply
  85. Alex Web Avatar
    Alex Web

    glad I found your article I spent a lot of hours figuring out what to do. Thank you

    Reply
  86. Vir Bhadra Yumnam Avatar
    Vir Bhadra Yumnam

    Thank you Juanfra, it worked. I really Appreciate

    Reply
  87. Mario Outten Avatar
    Mario Outten

    Thanks for the article. Solved the problem for me!

    Reply
  88. craig O Avatar
    craig O

    You helped me my man, thanks very much!

    Reply
  89. Schuyler Avatar
    Schuyler

    Worked like a charm. Thanks my friend!

    Reply
  90. Adrianne Avatar
    Adrianne

    Thanks! For the update fix for deleting last log file. Worked perfectly.

    Reply
  91. Alex Avatar
    Alex

    Worked!! Thank you for the assistance!

    Reply
  92. karthickeyan Avatar
    karthickeyan

    thanks, now worked after deleting the log files.

    Reply
  93. Marloes Avatar
    Marloes

    Saved my day! Thank you!

    Reply
  94. Jim Avatar
    Jim

    Thank you for this — the log delete trick worked!

    Reply
  95. Rob Avatar
    Rob

    Great fix thanks!

    Reply
  96. Neil Oppegaard Avatar
    Neil Oppegaard

    Thanks your update about deleting the files from the folder worked a treat! Had been struggling following both a power failure and it simply refusing to start up again so I am now back up and running. Many thanks

    Reply
  97. kristy Avatar
    kristy

    thank you so much for the 2017 update, the command in the terminal didn’t work, but deleting the logfile worked a treat!

    Reply
  98. Kelsey Avatar
    Kelsey

    Worked perfectly. Thanks so much.

    Reply
  99. Lehlohonolo Avatar
    Lehlohonolo

    Thank you, Problem sorted.

    Reply
  100. MLipenkranz Avatar
    MLipenkranz

    The 2nd method worked for me! Thanks!

    Reply
  101. Mangs Avatar
    Mangs

    If you’re using Mac, the below should work, but only as a last resort especially if you use WP:

    rm /Applications/MAMP/db/mysql56/*

    Reply
  102. iyiuyiyu Avatar
    iyiuyiyu

    Works fine Thanks

    Reply
  103. Andrea Avatar
    Andrea

    Oh my god. This post was a life saver! Thank you so much!

    Reply
  104. HASAN HAYDAROV Avatar
    HASAN HAYDAROV

    THANK YOU JUANFRA, big thanks to you.

    Reply
  105. Diseño web y Marketing Digital Avatar
    Diseño web y Marketing Digital

    good post!

    Reply
  106. How to install WordPress locally ( 2020 ) – UsableWP

    […] stop already running MySQL server, please refer to this answer on StackOverflow and this blog […]

    Reply
  107. Manuel Tito Martínez Peinado Avatar
    Manuel Tito Martínez Peinado

    Muchas gracias, Juanfra Aldasoro y ElCid.
    Hace tiempo estuve trabajando con una versión MAMP antigua, que desinstalé de mi MacOS. Para clonar una Moodle descargué Moodle4Mac-34.dmg que viene con la versión MAMP 4.1.1 pero como había cosas que no funcionaban tuve que quitarla. Cuando la volví a instalar observé que el archivo index.php del directorio htdocs indicaba su última línea ‘Something is wrong with your MAMP installation :-(‘ y al intentar conectar mediante phpMyAdmin con las bases de datos el navegador mostraba este mensaje:
    ‘Error
    MySQL ha dicho:Documentación
    #2002 – No such file or directory — El servidor no está respondiendo (o el zócalo local al servidor MySQL no está configurado correctamente).
    mysqli_real_connect(): (HY000/2002): No such file or directory
    Reintentar conexión’
    Buscando soluciones llegué a tu web 🙂 Probé tu solución primera sin éxito. Seguí a la segunda, pero en mi directorio Applications/MAMP/db/mysql/ no había ningún archivo llamado ib_logfileN sino una carpeta denominada mysql56 como indica ElCid en cuyo interior estaba el fichero ibdata1 de 79,7 MB que borré tras haber hecho copia de seguridad. Volví a iniciar MAMP y ¡problema solucionado!
    Muchísimas gracias a ambos.
    Un saludo cordial.
    Manuel Tito

    Reply
  108. MAMP mysql server won't start. No mysql processes are running

    […] The easiest solution: quit MAMP and remove the log files from MAMP/db/mysql directory [ib_logfile0, ib_logfile1] and restart MAMP. For more visit http://juanfra.me/2013/01/mysql-not-starting-mamp-fix/ […]

    Reply
  109. El servidor Mysql MAMP no se inicia. No se están ejecutando procesos mysql – mysql en Español

    […] La solución más fácil: salga de MAMP y elimine los archivos de registro del directorio MAMP/db/mysql [ib_logfile0, ib_logfile1] y reinicie MAMP. Para más visita http://juanfra.me/2013/01/mysql-no-arranca-mamp-fix/ […]

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

More posts