My SQL server setting in Coda 2

Category: Databases

fudesign
Asked:
2013-07-25 12:50 pm EST

Hits: 1,718
Hi, I am wondering how to setup mysql server in Coda editor? The fields are below:

Server : (tried localhost but didn't work)
User Name :
Password :
Database :

attached screenshot
https://dl.dropboxusercontent.com/u/11480833/Screen%20Shot%202013-07-25%20at%2012.49.44%20PM.jpg

Thank you very much.

You must login before you can ask a follow up question.

You must login before you can submit an answer.

OTHER ANSWERS

0

Arn
Staff
17,351 Points
2013-07-25 1:29 pm EST
Hello Fudesign,

Thanks for the question. The server is only set to localhost when the access to the database is coming from something running directly on the web server. In this case, you're using an application on your computer to access the database, so you will need to configure database access with your domain name (or the server name). The domain name can be used only if it's pointed to our server already. If it's not, then you should determine your server name and use that. Here's an example: bizXXX.inmotionhosting.com.

The user name and password are based on the user name and password that you setup for the database within the MySQL interface in cPanel. Note that you are not limited to a single user name accessing the database, but each assigned user name will need to be setup in the MySQL interface.

You will also need to setup a remote MySQL connection. Once you have that setup, then you will be able to access the database remotely. By the way, the default port of 3306 is correct - don't change that setting!

I hope this helps to answer your question. If you require any further assistance, please let us know!

Regards,
Arnel C.

You must login before you can post a comment about this answer.

Like this Question?

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!