Recently I’ve started working locally due to the PHPStorm IDE. In order to work locally, I invested in MAMP Pro to make use of their GUI interface for configuring vhosts. I also like to use MySQL Workbench for my database work, unfortunately these 2 items never seemed to work together for me before. After a brief google search I was able to find out how to connect to MAMP’s MySQL install to do SQL Development, which is by done by choosing the local socket connection method and using the value /Applications/MAMP/tmp/mysql/mysql.sock for the connection.
After setting that up, I got to thinking, “I’m already using an IDE for code convenience and a GUI for vhost convenience, I should set up Server Administration with MySQL Workbench too!” So after some googling, I found an article to help me set up Server Administration with MAMP. Unfortunately the article only got things partially working and has no way to comment on it to have it corrected. So I’m going to outline the steps. Also I just noticed that the images with the article are updated correctly but it’s hard to cut and paste an image of something someone has done so I’ll just give you the value pairs
- Configuration File: /Applications/MAMP/tmp/mysql/my.cnf
- Start: /Applications/MAMP/bin/startMysql.sh -
- Stop: /Applications/MAMP/bin/stopMysql.sh -
- Check MySQL Status: ps -xa | grep “/Applications/MAMP/Library/bin/[m]ysqld”