Configure Dreamweaver to access MySQL database via FTP – cPanel – Access database via remote connection

Introduction

Adobe Dreamweaver allows developers to connect to and manage MySQL databases remotely through FTP and Remote MySQL access in cPanel. Proper configuration of remote MySQL and Dreamweaver settings is required to establish a successful database connection.

---

Prerequisites

• Access to cPanel
• FTP credentials
• MySQL database username and password
• Adobe Dreamweaver installed
• Public IP address of your local machine

---

Implementation

Enable Remote MySQL Connection in cPanel

1. Log in to your cPanel.
2. Go to the Databases section.
3. Click on Remote MySQL.
4. Enter the Host Name.

Note:
The hostname should be either your IP address or domain name.

Example:

• 203.56.23.%
• backtoflowers.com.sg

You can find your public IP address from:

http://www.whatismyip.com/

---

Configure Dreamweaver/MySQL-Front

MySQL-Front Configuration

1. Open MySQL-Front.
2. Navigate to:

File → Connection

3. Click New.
4. Enter the name of the connection (example: domain name).
5. Go to the Connection tab.
6. Enter the hostname.
7. Go to the Login tab.
8. Enter the MySQL username and password.

(Optional: Enable Save Password)

Note:
You should now be able to browse and access the required database.

Click OK to connect and view the MySQL tables.

---

Dreamweaver Site Setup

1. Open the Site Manager.
2. Go to the Testing Server section.
3. Configure the following settings:

• Server Model = PHP MySQL
• Access = FTP
• FTP Host = ftp.domain.com
• Host Directory = public_html or public_html/dir
• Login = Domain FTP Username
• Password = Domain FTP Password
• URL Prefix = http://domainname.com

Important Note:
If an .htaccess file exists in the configured HTTP address path, temporarily disable it to allow Dreamweaver to access it properly.

---

Database Setup in Dreamweaver

1. Open the Application section.
2. Go to:

Window → Databases

3. Click the + icon and select MySQL Connection.
4. Enter the connection name.
5. For MySQL Server, enter:

localhost

6. Enter the MySQL username and password.
7. Enter the database name you want to connect to.
8. Click OK.

---

Troubleshooting Dreamweaver Database Connection Errors

If you receive the error:

“An unidentified error has occurred.”

Follow the steps below.

---

Step 1

Open your FTP program.

---

Step 2

Navigate to the root folder of your website.

(This is the Host Directory configured in Dreamweaver.)

---

Step 3

Check for a folder named:

_mmServerScripts

---

If the Folder Exists

1. Delete the _mmServerScripts folder.
2. Attempt the database connection again using Dreamweaver.
3. Dreamweaver will recreate the directory automatically.

---

If the Folder Does Not Exist

1. Create a new directory named:

_mmServerScripts

2. Navigate to the following directory on your local Dreamweaver installation:

Configuration\Connections\Scripts\PHP_MySQL_mmDBScripts

3. Upload the following files into the _mmServerScripts directory on your server:

• MMHTTPDB.php
• mysql.php

---

Conclusion

By enabling Remote MySQL access in cPanel and configuring the required FTP and database settings in Adobe Dreamweaver, you can successfully connect and manage your MySQL databases remotely.