Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I installed MySQL with homebrew. When I run mysql.server start I get the following error:

ERROR!The server quit without updating PID file (/usr/local/var/mysql...
local.pid

I have searched this site and googled this and I do what it tells me to do but I've had no luck.

share|improve this question

migrated from stackoverflow.com Nov 14 '12 at 4:59

This question came from our site for professional and enthusiast programmers.

1  
Instead of any init.d script, start mysqld in the foreground without forking, and it will probably tell you why it fails. –  Wrikken Nov 13 '12 at 22:57
    
Ok, I get the following error and I don't know how to fix it: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) –  Jennifer Nov 14 '12 at 0:11
1  
mysqld NOT mysql .... In other words: start an unforked mysql instance with stdout & stderr to your console. –  Wrikken Nov 16 '12 at 13:13

2 Answers 2

Firstly, you can use mysql_install_db to install your MySQL system tables. Then you can use mysql.server start.

share|improve this answer

What have you tried so far? Did you run the following after installation:

brew info mysql

If you did, it might be a problem with permissions. You might need to give the user permission to write to the PID file.

share|improve this answer
    
How do I exactly do that? I did sudo chown -R [user name] PID. This is probably wrong because I work with the hardware side of the computer not the software part until now. Thanks for your help! –  Jennifer Nov 14 '12 at 16:53

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.