tool kit

apps I use to get the job done

SequelPro Icon

SequelPro

Learn more at: sequelpro.com

When I access a MySQL database to add or manage databases and tables, I prefer using a MySQL tool rather than the command line. The best tool for this out there is SequelPro (formerly Cocoa MySQL). SQL has a more intuitive user interface than phpMyAdmin, and makes managing data simple and quick. I can connect to local or remote databases, save favorites, run SQL queries and manage table info like columns, encoding and size.

SequelPro Screenshot #1
SequelPro Screenshot #2
SequelPro Screenshot #3

Tips

Use it for remote access to your MySQL databases
In most cases, though, you'll need to request specific access from your host. Your host should be able to provide access to the databases from your IP. It's WAY faster than using phpMyAdmin, which in my experience, most Apache hosts provide.

See All