CODEWITHSUNDEEP
mysqlmacososx-yosemite
Whitecat
Whitecat

Reputation: 4020

Mysql won't start after upgrading Mac OS X Yosemite (Mac OS 10.10)

Right after upgrading to Mac OS Yosemite (10.10), my Mysql won't start anymore. Instead I get

MacBook-Pro:/ user$ sudo /usr/local/mysql/support-files/mysql.server start
Starting MySQL 
. ERROR! The server quit without updating PID file (/usr/local/mysql/data/wireless.ubc.ca.pid).

I tried to check version number but I also get the following error

MacBook-Pro:/ user$ /usr/local/mysql/bin/mysql -v
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I found lots of people having problems with XAMPP not working after Yosemite install, Also eclipse not working. I see many people just say reinstall. Is there anyway to fix this?

Upvotes: 10

Views: 18468

Answers (4)

Stephen Brown
Stephen Brown

Reputation: 31

After updating MySQL I also for some reason have to change the permissions of the MySQL dir for it to work. The installer always changes the permissions to root.

chown -R _mysql:wheel /usr/local/mysql-5.6.21-osx10.8-x86_64/

Upvotes: 3

DanMonroe
DanMonroe

Reputation: 155

None of these answers worked for me. I reinstalled mysql using homebrew and it worked.

http://blog.joefallon.net/2013/10/install-mysql-on-mac-osx-using-homebrew/

Upvotes: 1

Bilal Ahmed
Bilal Ahmed

Reputation: 182

I don't think so this installation is needed. I got the same issue when I upgraded to Yosemite.

I tried to run the mysql server through command line but it failed, saying

Starting MySQL .... ERROR! The server quit without updating PID file (/usr/local/var/mysql/Bilals-MacBook-Pro.local.pid).

I went in preferences and clicked mysql there, and it was stopped. Start mysql from preferences which will ask for root password, and it worked :)

Upvotes: 4

Marcelo Gaia
Marcelo Gaia

Reputation: 126

I haven't yet updated to Yosemite yet but I had this link saved when I do:

Get Apache, MySQL, PHP and phpMyAdmin working on OSX 10.10 Yosemite

This specific line may do some good:

sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock

But check the whole post and let me know if it helps!

Good luck!

Upvotes: 9

Related Questions