Problem with MySQL Server

same problem, i did follow this guide yesterday and apache, php and mysql seems to work

today after reboot i'm not able to start mysql

i did follow this guide

http://coolestguidesontheplanet.com/get-apache-mysql-php-phpmyadmin-working-osx- 10-10-yosemite/

i noticed that mysql.sock link is gone, but recreating doesn't fix it

$ sudo /usr/local/mysql/support-files/mysql.server start

Starting MySQL

.... SUCCESS!

if i try to connect i get

$ mysql -u root -p

Enter password:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

if i check in var/mysql mysql.sock is gone

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

$ mysql -u root -p

Enter password:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (62)

this time i get 62 instead of 2

Create /Library/LaunchDaemons/com.mysql.mysql.plist and save it with the following plist:

    <!--?xml version="1.0" encoding="UTF-8"?-->    <plist version="1.0">      <dict>       <key>KeepAlive</key>       <true>       <key>Label</key>       <string>com.mysql.mysqld</string>       <key>ProgramArguments</key>       <array>       <string>/usr/local/mysql/bin/mysqld_safe</string>       <string>--user=mysql</string>       </array>      </true></dict>    </plist

Then load the newly created plist file with

sudo launchctl load -w /Library/LaunchDaemons/com.mysql.mysql.plist

"ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" --this error occurred when I upgraded from Mavericks to Yosemite. And I have tried a lot of methods but all did not work.

This solution helped me fix it. Thank you. Hope more people can see it!

Got an error with your plist, terminal said somewhere was an invalid property. So finally this one make it work:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
  <dict>
   <key>KeepAlive</key>
   <true/>
   <key>Label</key>
   <string>com.mysql.mysqld</string>
   <key>ProgramArguments</key>
   <array>
   <string>/usr/local/mysql/bin/mysqld_safe</string>
   <string>--user=mysql</string>
   </array>
  </dict>
</plist>

And also changing some permisions to the file:

sudo chown root /Library/LaunchDaemons/com.mysql.mysql.plist
sudo chgrp wheel /Library/LaunchDaemons/com.mysql.mysql.plist
sudo chmod 644/Library/LaunchDaemons/com.mysql.mysql.plist

And finally load the plist:

sudo launchctl load-w /Library/LaunchDaemons/com.mysql.mysql.plist

Based on a SO answer.

actually a make the plist thing and the cmod thing and they show me the ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

than a check the process on active monitor called mysqld and make

killall mysqld than when y try on terminal mysql to make a login they works

for some reason the process is already running i think for this they cannot start o something

see?

sudo launchctl load -w /Library/LaunchDaemons/com.mysql.mysql.plist

/Library/LaunchDaemons/com.mysql.mysql.plist: Operation already in progress

they show me this