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 Kunder som kunne bruge dette svar
Hjalp dette svar dig?

Related Articles

How do I connect to the MSSQL server with my ASP.Net script?

The database server is on a separate server so you will need to use the server IP in your...

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 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...

How do I connect to MS SQL Server 2005 ?

We provide a MS SQL login and password for your SQL database. Connect to the online SQL server...