How do I connect to my database from Dreamweaver MX?

We're going under the assumption that you have already set up a MySQL
database on your server.

When you set up your site in Dreamweaver make sure these are your settings:

Local info

Site Name: Whatever you like

Local Root Folder: Navigate to where you keep your files for the site on
your home computer

HTTP Address: http://yourdomainname.com/

Remote info

Access: FTP

FTP Host: yourdomain.com or servername.webcomindia.net(change to your domain or server name)

Host Directory: public_html/ (or public_html/subfolder/ for addon domains)

login: cpanel username

password: cpanel password

Check the box for "use passive FTP"

Do NOT check the box for "use firewall" (very important!)

As far as check in/check out, unless you have some specific reason to do so, do not check any of these boxes.

If you hit "test" after you set up these settings, you should be able to
connect.

Testing Server

Server Model: PHP/MySQL

All other settings should be the same as in the Remote Info, except for
URL Prefix: http://yourdomainname.com

Database Connection

Now create a PHP page by clicking on New, Dynamic Page, PHP or open an existing PHP page.

Open the Applications panel.

The first three of four steps should have check marks next to them.

For step four, click the "+" button, and select MySQL connection from the
drop-down list.

Connection name: whatever you would like to name it - it doesn't matter.

MySQL Server: localhost

Username: cpanel username

Password: cpanel password

Database: click "select" and in a few seconds (depending on your
connection speed) you should get a list of available databases you can
connect to.

  • 7 Users Found This Useful
Was this answer helpful?

Related Articles

How do I connect to MS ACCESS Database on Windows 2003 Server ?

Upload your MS Access database on the root folder. Create a System DSN and give the Access mdb...

Can I have oracle database support on Windows 2003 Server?

No. As of now we do not have oracle on Windows Server.

What are the connection settings for my MySQL database?

The hostname to connect to is "localhost" if connecting from a script on the server, or your...

How do I create a database in MySQL?

You can create a database via your control panel by clicking on the mySQL icon. Here is a link...

How do I set up my PC to connect to MSSQL Server database at Webcom Systems Web Hosting?

Setting up your PC to connect to your SQL Server database at Webcom Systems Web Hosting is...