We have previously stated that we think SiteGround is a great host for developers, and so when we came across a little tutorial to integrate SiteGround MySQL with Coda 2 by Mike Hemberger, we reached out to him to see if we could reproduce the tutorial, and he happily agreed.
Mike Hemberger is freelance web designer and developer working with the name "The Stiz Media" (http://thestizmedia.com). He has a passion for design and a longing for creativity that shines through in everything he does.
Essentially, if you love Coda 2 (which we do), then this short tutorial will enable you to use the MySQL editor that is built into Coda 2 to connect Coda 2 MySQL with SiteGround Databases.
Coda 2 is a fantastic simple, clean and powerful OS X app that allows you to manage your local and remote website files. While this short tutorial focuses on the MySQL integration, it is a suite that enables you to code easily entire websites easily with incredibly clear and helpful syntax highlighting.
SiteGround Coda 2 MySQL Settings and Setup
Go to “My Accounts” then “Manage Account.”
The settings must be configured for each account, so you will have to repeat these steps for each account you want access to.
Under “Account DNS” you need to copy the IP address that’s after ns2.sitegroundXXX.com
Click “Go to cPanel.”
Under the “Databases” section select “Remote MySQL.”
In the “Host” field, paste the IP address from Step 3, and click “Add Host.”
Coda 2 Settings and Setup
Add new site, or choose which the site you want to access the MySQL.
Set “Database Type: MySQL Server.”
Server: Paste the IP address used in Steps 3 and 6
User Name and Password: Enter the username and password associated with the database you want to access. Note that you will gain access to all of the databases within your SiteGround count upon providing the information for just one of the databases.
Initial Database: This should contain the name of the initial database you want to access. You should ensure the name matches precisely. Make sure the username and password above are already users of this database.
Save and connect!
Once you have connected, you will be able to add a new MySQL document and use the dropdown on the top left to select which database you wish to connect to.