This post suggested that it was because MySQL is installed but not yet running. Trying to run mysql -u root mysql, I received the following error:ĮRROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) This post-install step was failing with no useful hint on the true problem: shell> /usr/local/Cellar/mariadb/10.4.11/bin/mysql -u root mysql I came up with a solution thanks to this post, the problem wasn't with (or wasn't just with) my.cnf. My issue was due to a previous Homebrew MySQL installation. Maybe it's helpful for others, I'll post here the solution that worked for me.

True story, learning Docker is on my to-do list! I'd recommend not doing anything natively and simply spin up a docker container.

Interesting to see everyone is still struggling with this 6 years later. I just have no idea, regarding what is wrong. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Kitchen-sync bottle with mariadb - Library not loaded Check that you have the necessary permissions and try again. This means that you should use IP addresses instead of hostnamesĬhown: /usr/local/var/mysql: Operation not permittedĬannot change ownership of the database directories to the 'varundavda' Normally with the exception that host name resolving will not work. This probably means that your libc libraries are not 100 % compatible WARNING: The host 'Varuns-MacBook-Pro.local' could not be looked up with resolveip. profile alias mysql='mysql -h 127.0.0.I am getting the below error when i install mariadb using brew. To make that easier, just create an alias in the. Note, using Docker, you will need to force a TCP/IP connection to your MySQL container: mysql -u username -p -h 127.0.0.1 Close your terminal, open it again, and you should be good to go. Once MySQL Workbench is installed, you just need to add the path to the mysql binary to your path: /Applications/MySQLWorkbench.app/Contents/MacOS

Since I wanted MySQL Workbench installed anyway, this seemed like the easiest solution for me. You can’t download the client only from the MySQL Community Edition site (at least for Mac). If, like me, you are using Docker or some other type of virtualization to provide a MySQL service for your Dev environment on a Mac, you will find that you do not have a MySQL client installed.

Mysql client mac brew