Published by Mijingo
movie icon image

EE Insider Blog

Spend your time learning and developing sites with ExpressionEngine and we'll use this blog to keep you informed of all the news related to ExpressionEngine and CodeIgniter.

» Read more in the Archives.

» Have a tip? Send us your EE news.

Learn ExpressionEngine Today

Over a series of 8 videos, watch and learn as Ryan builds an entire ExpressionEngine website from beginning to end. Get started now.

Sequel Pro

Sequel Pro iconA recent post on Daring Fireball reminded of an app I’ve been using regularly for the last few months: Sequel Pro, a free MySQL management application for Mac OS X. I’ve previously used CocoaMySQL—which has been abandoned and turned into Sequel Pro—and before that YourSQL. YourSQL stopped working for me on Leopard, so I ditched it. Sequel Pro is a nice step forward.

If you’ve read my article on developing ExpressionEngine websites locally you might find this tip handy for using Sequel Pro with MAMP.

  • Create a new favorite called “MAMP.”
  • Set “Host” to “localhost” and fill in your MySQL username and password (by default MAMP uses “root” for both).
  • Set “Socket” to /Applications/MAMP/tmp/mysql/mysql.sock

Now when you connect, you’ll be using the MySQL server from MAMP.

 

 

Posted on Feb 23, 2009 by Ryan Irelan

Filed Under: Development Tools

Adam khan — 11:41 on 02.23.2009

Excellent, and thanks for the setup tips.

Matthew Pennell — 22:13 on 02.23.2009

Despite trying a few different standalone MySQL apps (including Sequel Pro, apparently, although I don’t remember it), I still keep going back to PHPMyAdmin. I think the familiarity and ease-of-use make it the quickest solution for me - plus I can get at it on my live site remotely.

Jason Hudnutt — 19:05 on 03.04.2009

I found this a while ago and i think it blows Sequel Pro out of the water! It supports automatic backups as well!

http://dev.mysql.com/downloads/gui-tools/5.0.html

MarmaladeToday — 03:15 on 05.17.2009

Thanks Ryan - your socket tip just helped me get this sorted. Previously I’d just been getting an error. Will be checking out Jason’s recommendation a little later too.