The in my case the path to the socket should have been: socket = /opt/local/var/run/mysql5/mysqld.sock So I had to define the path to the socket in the my.cnf for both the and configurations. Most programs have a hard coded default that can be overridden, I had overridden the macports default to the one php is compiled to, so you need to tell the client what you've changed it to otherwise how is it supposed to know.īecause I did not have a copy of my.cnf in opt/local/share/mysql5/mysql, the client did not know where to look for the socket. I also learned that if you've changed the socket path away from the default then you need to tell everything where it is.

The default configuration of macports mysql does not come with a my.cnf (it does however have others my-medium.cnf, my-small.cnf) so the Macports mysql client is going to look where the Macports server is set to look. I was getting the following error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/local/var/run/mysql5/mysqld.sock' (2) When you try to connect via: mysql5 -u root -p When you update to El Capitan from a previous version of OSX your mysql settings get lost.

I would like to share the solution that I came across to resolve this issue. php scripts in my browser the mysql queries work and the data is being retrieved. Interestingly, mysql must be still working because when I run an. So the structure is similar to what was on my old Mac but I confused as to what is causing mysql to not start? When I navigate to my mysql5 directory /opt/local/var/db/mysql5/ I see a list of my databases, and see the following PID files:

I've also tried restarting mysql: sudo opt/local/share/mysql5/mysql/rver restartĪnd got the following error: ERROR! Manager of pid-file quit without updating file. However I am now unable to start mysql from terminal?Īnd got the following error: Error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/local/var/run/mysql5/mysqld.sock' (2) So I've managed to get my localhost and php working on the new machine. I also re-installed macports and configured apache etc. I recently upgraded my Mac Pro to a Mac Mini and used the migration assistant to transfer all my files and applications across to the Mac Mini.

Upgrade mac os el capitan to sierra