This morning I had to do some heavier editing of database tables, so I wanted to take the opportunity to test the MySQL editor that’s built in to Coda 2.
It’s actually really simple, you just need to know exactly what to input into each field, and where to find that info.
First off… if you don’t use SiteGround (aff), I consider it the best bang for hosting WordPress websites.
SiteGround Settings and Setup
Login to your SiteGround account
Go to “My Accounts” then “Manage Account”
If you have more than 1 account, you’ll want to choose the account for which you want to setup in Coda 2. You’ll 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 choose “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 the site you want access MySQL in.
Set “Database Type: MySQL Server”
Server: Paste the IP address used in Steps 3 and 6
User Name and Password: Copy and paste the username and password associated with the database you want to access.
(Tip: You only need to use the settings for 1 database. After you’re in, Coda will give you quick access to all of the db’s in your SiteGround account)
Initial Database: Paste the exact name of the initial database you want to access. Make sure the username and password above are already users of this database.
Save and connect!
Once you’re in, add a new MySQL document and use the dropdown on the top left to choose which database you want to connect to. So far, I’m loving using Coda much more than PHPMyAdmin!