Skip to main content
V
vishu00987
Participant
January 5, 2015
Question

Create Connection to MYSQL database which is on server using Dreamweaver CC

  • January 5, 2015
  • 1 reply
  • 4592 views

Hello,

       I created a site using Dreamweaver CC and i have used the FTP server for this. Now i want to connect it to the database that i created on my server with the table. I am unable to figure out what IP address should i provide to connect to the database as my database is not running locally. I have added the screenshot as well. Kindly help me.

This topic has been closed for replies.

1 reply

BenPleysier
Community Expert
BenPleysierCommunity Expert
Community Expert
January 5, 2015

There are very few hosts which allow remote connections to their MySQL databases for security reasons.

I usually develop the site locally using a local database. When I have finished I will use a query to update the remote database.

Wappler is the DMXzone-made Dreamweaver replacement and includes the best of their powerful extensions, as well as much more!
Rob Hecker2
Rob Hecker2
Legend
January 5, 2015

This has been discussed a few times recently. If your remote server is a VPS or dedicated server, you can do this; otherwise, as Ben said, you probably cannot.

Whether on VPS, dedicated or shared hosting account, you will need to have your local computer ip address added to the allowed list for mysql access.

I do as Ben does. I work with a copy of the database on a local MySQL server. This allows you to experiment and make mistakes without fear of destroying data on the remote server.

V
vishu00987Author
Participant
January 5, 2015

So i just create my database on the localhost and just copy the code when i check it on the remote server, right?

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices