Tonight after my first reboot in a long time, MySQL suddenly stopped working – I couldn’t connect from Sequel Pro, and when I tried to fire up the cli, I got the error below:
mysql: Can't read dir of '/usr/local/etc/my.cnf.d' (Errcode: 2 - No such file or directory) mysql: [ERROR] Fatal error in defaults handling. Program aborted!
I don’t know if this is a common issue, but figured I’d write up the solution here. I’m not sure why the directory no longer exists, or why MySQL worked without it before, but I just ran
mkdir /usr/local/etc/my.cnf.d and everything was back to normal.