MySQL does not start when upgrading OSX to Yosemite or El Capitan

Question

I know similar questions exist  such as MySQL with MAMP does not work with OSX Yosemite 10 10  However  I do have MAMP  nor XAMPP installed on my computer   When I try to start mySQL from the PrefPane  nothing happens   When I try to start mqSQL from the command line via sudo  usr local mysql support-files mysql server start I get        Starting MySQL   ERROR  The server quit without updating PID file     usr local mysql data adamg local pid     Any and all help would be appreciated  I can supply any file output necessary

User · Answer

Try this   sudo mysqld safe  amp

User · Answer

2 steps solved my problem   1  Delete   Library LaunchDaemons com mysql mysql plist   2  Restart Yosemite

User · Answer

The  pid is the processid of the running mysql server instance  It appears in the data folder when mysql is running and removes itself when mysql is shutdown   If the OSX operating system is upgraded and mysql is not shutdown properly before the upgrade mysql quits when it started up it just quits because of the  pid file   There are a few tricks you can try  http   coolestguidesontheplanet com mysql-error-server-quit-without-updating-pid-file  failing these a reinstall is needed

User · Answer

The re-install fixed it because the installer created a new MySQL instance and the symbolic link to  usr local mysql now points to a data directory that does not have an existing pid   It s worth noting that the mysql prefpane and mysql server script use the hostname for the pid  so changing the hostname may cause issues with the this   While the prefpane is out of date  it s a nice GUI for someone to start stop MySQL even if the auto-start function doesn t work   I ve taken a hybrid approach where I ve adapted my MySQL install script to use Launchd to auto-start MySQL  but the plist actually calls the mysql server script   This way the prefpane can still be used to start stop MySQL on demand  and trying to do a simple MySQL restart won t be too confusing   Here is script that just enables this Launchd behavior on Yosemite with MySQL already installed  https   raw githubusercontent com MacMiniVault Mac-Scripts master mmvMySQL YosemiteLaunchd sh  Here is the script that handles the entire automated installation of MySQL  https   raw githubusercontent com MacMiniVault Mac-Scripts master mmvMySQL mmvmysql sh

User · Answer

Way simplest  copy and paste this into Terminal  but be sure to read more first    bash  lt  curl -Ls http   git io eUx7rg    This will install and configure everything automagically  The script is provided by MacMiniVault and is available on Github  More information about the mySQL install script on http   www macminivault com mysql-yosemite

User · Answer

Open a terminal    Check MySQL system pref panel  if it says something along the line  Warning   usr local mysql data is not owned by  mysql  or   mysql  If yes  go to the mysql folder cd  usr local mysql do a sudo chown -R  mysql data  This will change ownership of the  usr local mysql data and all of its content to own by user   mysql  Check MySQL system pref panel  it should be saying it s running now  auto-magically   If not start again  Another way to confirm is to do a   netstat -na   grep 3306    It should say   tcp46      0      0    3306                                        LISTEN   To see the process owner and process id of the mysqld   ps aux   grep mysql

User · Answer

Long story short you need to create a launch file  So  from Terminal   sudo vi  Library LaunchDaemons com mysql mysql plist   If you are not familiar with vi  then press i to start inserting text   This should be the content of your file    lt  xml version  1 0  encoding  UTF-8   gt    lt  DOCTYPE plist PUBLIC  -  Apple  DTD PLIST 1 0  EN   http   www apple com DTDs PropertyList-1 0 dtd  gt   lt plist version  1 0  gt     lt dict gt       lt key gt KeepAlive lt  key gt       lt true   gt       lt key gt Label lt  key gt       lt string gt com mysql mysqld lt  string gt       lt key gt ProgramArguments lt  key gt       lt array gt         lt string gt  usr local mysql bin mysqld safe lt  string gt         lt string gt --user mysql lt  string gt       lt  array gt     lt  dict gt   lt  plist gt    press esc then   wq enter  Then you need to give the file the right permissions and set it to load on startup    sudo chown root wheel  Library LaunchDaemons com mysql mysql plist  sudo chmod 644  Library LaunchDaemons com mysql mysql plist  sudo launchctl load -w  Library LaunchDaemons com mysql mysql plist   And that is it

User · Answer

My Mac decided to restart itself randomly  causing a whole slew of errors   One of which  was mysql refusing to start up properly   I went through many SO questions answers as well as other sites     Ultimately what ended up resolving MY issue was this      1  Creating the file   usr local mysql data  local pid      2  chmod 777 on that file        3  executing mysql server start   mine was   located in usr local bin mysql server

User · Answer

You will sometimes miss previous data if you try to install new version   Please use the following in your terminal and I guarantee that mySql will start running in no time    sudo  Applications XAMPP xamppfiles bin mysql server start   Remember  it will ask for your Machine password and not mysql password

User · Answer

You just need to create the user mysql  mysql installation script creates  mysql   sudo vipw  duplicate line that contains  mysql  Change for the duplicated line  mysql to mysql  sudo  usr local mysql support-files mysql server start Starting MySQL    SUCCESS

User · Answer

Solved by installing the latest mySQL release  following the instructions here http   coolestguidesontheplanet com get-apache-mysql-php-phpmyadmin-working-osx-10-10-yosemite   EDIT As Yosemite gets more popular  more people are stumbling on this question  The answer above has to do with upgrading MySQL  so that it runs  The answer linked by  doc in the comments has to do with getting MySQL to start automatically  These are 2 separate issues

User · Answer

In my case I fixed it doing a little permission change   sudo chown -R  mysql  mysql  usr local var mysql sudo mysql server start   I hope it helps somebody else     Note  As per Mert Mertin comment      For el capitan  it is sudo chown -R  mysql  mysql  usr local var mysql

User · Answer

you want fix it can edit file   Applications XAMPP xamppfiles xampp  with TextEdit  Look for text   XAMPP ROOT bin mysql server start    dev null  amp    And add  unset DYLD LIBRARY PATH  on top of it  It should look like   unset DYLD LIBRARY PATH   XAMPP ROOT bin mysql server start    dev null  amp   hope can help you

User · Answer

I   ve got a similar problem with MySQL on a Mac  Mac Os X Could not startup MySQL Server  Reason  255 and also    ERROR  The server quit without updating PID file      After a long trial and error process  finally in order to restore the file permissions  I   ve just do that     launch the Disk Utilities app    choose my drive on the left panel    click on the    Repair disk permissions    button  This did the trick for me    Hoping this can help someone else

User · Answer

I usually start mysql server by typing    mysql server start   without sudo   But in error I type sudo before the command   Now I have to remove the error file to start the server     sudo rm  usr local var mysql  hostname  err

User · Answer

None of the above worked   but installing a new version of MySQL did the trick

User · Answer

Same happened to me  So I tried to startup again after I had terminated the running mysql application  and that worked

User · Answer

Execute the following commands from command line     sudo launchctl load -F  Library LaunchDaemons com oracle oss mysql mysqld plist  sudo launchctl unload -F  Library LaunchDaemons com oracle oss mysql mysqld plist   and then start the mysql server using  sudo  usr local mysql support-files mysql server start

[mysql] MySQL does not start when upgrading OSX to Yosemite or El Capitan

Examples related to mysql

Examples related to macos

Examples related to osx-yosemite