If you’ve recently installed or upgraded to Coda 2, are using MAMP to manage your development stack, and are looking to use the built-in MySQL frontend, here’s what you need to do in order to connect to MySQL in Coda 2.

Coda 2 and MAMP MySQL Socket

Setting up a connection between your project and its database is easy. It really only takes a single step though it assumes you know the username and password to your local database (which I can’t imagine why you wouldn’t know it :).

MySQL in Coda 2

First, select ‘MySQL Socket’ from the Connect To area then paste the following line into the ‘Socket’ field:

`/Applications/MAMP/tmp/mysql/mysql.sock`

This will then allow Coda to connect to the databases you’ve likely been managing with another client such as phpMyAdmin.

In the comments, Gavin asked how to store the settings for a given site or application. To do this:

  • Go to the Coda 2 home screen where it lists all of your projects.
  • Two-finger click on the site and click on ‘Edit’
  • Click on the ‘Database’ tab and enter the socket information

Coda 2 Edit Site

This will store the settings so you won’t have to enter it each time for each site.