you are on my articles page.

Awesome MAMP fixes when MySQL server won’t start

  • November 5th, 2011
  • posted at 12:21 pm
  • by ivana

MAMP
Hello geeks,

Today I was planning on setting up WordPress locally using MAMP. I was totally geared. MAMP checked, ScoutApp checked(Awesome Compass & SASS app), coffee checked, brain checked. I also prepared that things will fuck up, considering how unlucky I am in this particular coding department; So of course, I didn’t forget to put my gay-rose-beer for stress peak helper.

Anyway, my problem was my MySQL Server didn’t and/or couldn’t start on MAMP. Lame, I know. So I was googling around, tried out some stuff that didn’t seem to work; Until… DUM DUM DDDUUUUMMM

Fix #1(source: http://twob.net/)

  • 1. Quit MAMP
  • 2. Go to your terminal and type killall -9 mysqld
  • 3. Restart MAMP, bitcheeess

For most people, this step is enough. But what happened with me was a bit unordinary. MySQL was still red after I typed type killall -9 mysqld on terminal. My first thought was “goddamnit! I knew it!! It wouldn’t be this easy for me!

Wait! don’t be too sad, second step will work like a charm and super-fantastic-awesome.

Fix#2
get your hands dirty, we’ll do this manually.

  • 1. Go in MAMP folder >> MAMP/db/mysql/
  • 2. Delete all files but LEAVE FOLDERS ALONE – don’t touch it, don’t even think bout touching it!
  • 3. Do not panic. You’re not losing your database(s), again, as long as you leave the folders alone
  • 4. Open MAMP and be happy

That’s all :) Short Saturday post for me. I am still lazy of course :-/ unfortunately.

OH! I am super excited to tell you guys about my fun-side-project. I am planning on publishing some articles; Written, designed, and drawn by independent artists out there. Here is the sample of my first article, let me know if you’re interested in contributing ;)