If you have MySQL server installed through Homebrew, we don’t expect you are facing any connection related problem. Bellows are focused on ´ MySQL-Python´, ´ mysqlclient´ installation problems and solutions. This writing for those concerns who don’t have MySQL server installed into MacOS powered development machine (like MacBook Pro) but need to work with MySQL connection through programming languages (i.e Python in my case).

I am the mad (maybe fool) guy who doesn’t prefer to install services (like MySQL, PostgreSQL and so on) into development machine, instead using docker containers, this way gives me a lot of flexibilities, for example, I could have multiple versions of MySQL servers (each version could be project-specific depends on requirements), besides no unnecessary processes are running in my development machine. Solve that issue I manually create a file named “my_config.h” at /usr/local/opt/mysql-client/include/mysql and put contents from here Preface Username is “root” and password the same as chosen in the previous step, for me that’s “password”.The latest version of you might don’t need to go Configure mysql_config section as I see that is already correctly configured.īut one file “ my_config.h“ is missing, you will feel that when you are going to install “ MySQL-Python“. The database to connect to is on localhost so set “host” to “127.0.0.1”. In case you are wondering, I am not actually affiliated with it in anyway.ĭownload and install Sequel Pro and open it.

I use Sequel Pro to manage MySQL because it has a pretty great UI. Once installed and running, MySQL is accessible to any app running locally on your machine. Set a rudimentary password for MySQL locally, there is no need to worry about security because it will only be accessible from your machine (I used “password”). To do this, use brew to start the MySQL daemon. You will want to keep MySQL running whenever your computer is started. Run this command to install MySQL brew install mysql Update Homebrew to ensure you get the latest packages brew update usr/bin/ruby -e '$(curl -fsSL )' Install MySQL Run the following command in a terminal window to install Homebrew. If you do not have Homebrew it will print nothing. If you have Homebrew it will print something similar to /usr/local/bin/brew. If you are not sure, run the following command. If you already have Homebrew, you can skip this section. Homebrew is a package manager for Mac and serves a similar purpose to apt-get in Linux.

This short tutorial shows how to install MySQL on a Mac using Homebrew and how to verify it is running using Sequel Pro.

Mac mysql client brew