Two of my favorites Mac database management application to work with MySQL databases are MySQL Workbench and my recent discover, Sequel Pro. As I was installing Sequel Pro, I encountered some problems so we'll go over them here to facilitate you the installation process and save you time.
I will assume that you already have MySQL installed, if not, click here to do so.
We need to apps two get this going. For DB management we'll use as you guessed Sequel Pro and for our cross-platform web server solution we'll use MAMP, you can also use XAMPP, but that's not the point here. So let's get them going. Downloads:
The reason we are downloading the test builds version of sequel is so we avoid errors connecting to MySQL later on like this one:
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
For now, MAMP will give you a free trial, use it to set things up since apparently the ports can't be configured in the new free version and it's more visual. So open up MAMP Pro and use the free trial. Click on MySQL and click on Check Health, if MySQL is not running, start it by typing on a new terminal window:
brew services start mysql and check the health again. If OK, and you have not set/change your MySQL password, click on Change password. To be able to connect without sockets, enabled the option that says: Allow Network access to MySQL (only on your mac). Now go ahead and turn on MySQL on the left panel.
Next, let's run Sequel Pro. This is what you have to type:
TCP/IP Host: 127.0.0.1 Username: root Password: (the one that you set on the set above) Port: 8889 And click Connect
Now your environment should be up and running gracefully.