macOS Mysql MariaDB SequelPro homebrew error: Program aborted!

Issue:

  • You can not login mysql in terminal when doing mysql -u root or mysqld you may see such error:
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!

Or you can not login Sequel Pro via Host:127.0.0.1. It alarms you:

sequel pro MySQL said: Can’t connect to MySQL server on ‘127.0.0.1’ (61)

Just open the config file at /usr/local/etc/my.cnf with your editor and comment out the following line:

!includedir /usr/local/etc/my.cnf.d

It should be the same as :

# !includedir /usr/local/etc/my.cnf.d

That’s the solution.

Written by

Web geek, Self-taught full-stack web developer, Learning Python, Laravel, Vuejs, UX/UI design, Nuclear Physicist PhD

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store