PhpRiot
News Archive
PhpRiot Newsletter
Your Email Address:

More information

Using MySQL Workbench with MAMP

Note: This article was originally published at Planet PHP on 7 October 2011.
Planet PHP

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 valueA/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:A/Applications/MAMP/bin/startMysql.sh -
  • Stop:A/Applications/MAMP/bin/stopMysql.sh -
  • Check MySQL Status:Aps -xa | grep "/Applications/MAMP/Library/bin/[m]ysqld"
If the check status doesn't work, just do a ps -xa | grep MAMP and find the correct path to mysqld And that's all you need to know. "/

Truncated by Planet PHP, read more at the original (another 810 bytes)