Follow the following steps to connect your Coda 2 app to your MySQL database hosted on your Mac’s Mamp install.

  1. Open Coda 2
  2. Edit your Site’s preferences. (File > Sites > Edit Site > example.com)
  3. Click the Database tab
  4. For ‘Database Type’ select; MySQL Socket
  5. For ‘Socket’ enter; /Applications/MAMP/tmp/mysql/mysql.sock
  6. Enter your database user name and password.
  7. Enter your database name. This is optional but avoids you having to reselect your database every time you open the database tab in Coda.
How to Connect Mamp Pro MySQL to Panic Coda
How to Connect Mamp Pro MySQL to Panic Coda