Bluehost Web Hosting Help

Dreamweaver MX Configuration for PHP and MySQL

Problem:

How do I configure Dreamweaver MX for PHP and MySQL?

Solution:

Here are the settings for Dreamweaver MX with PHP and MySQL:

Create the MySQL Database and User

  • Log into your Bluehost account and click on "MySQL Databases"
  • Create a new database if needed. For help creating MySQL databases, Click Here.
  • Under "Users" create a new user and password if you don't already have one you want to use. For help creating MySQL users, Click Here.
  • Add that user to the database. It is common to grant all permissions unless otherwise instructed.
  • Add your IP address to the "Allowed Host" listing. Alternatively you may add the * symbol. This is a wildcard and will allow connection from any computer if they have the correct user name and password.  Click Here for more information.

Now open Dreamweaver, create a new blank PHP page, then at the top bar click on "Site" then "New".

Leave the "Local Info" as it is. Use the following Remote and Testing Server settings:

Remote Info:

  • Access: FTP
  • FTP Host: domainname.com
  • Host Directory: public_html (this is the folder that your site loads to)
  • Login: *********
  • Password: *********
  • Passive FTP Box is checked!

Testing Server:

  • Server Model: PHP/MySQL
  • Access: FTP
  • FTP Host: domainname.com
  • Host Directory: public_html
  • Login: *********
  • Password: *********
  • Passive FTP box is checked!
  • Url Prefix: http://www.domainname.com

Open the MySQL Connections Dialog Box. It is in the application window (on the left side) under the databases tab.

MySQL Connections Dialog Box:

  • Connection Name: (whatever you name your connection)
  • MySQL Server: localhost.
  • User Name: (a database username that has access to the MySQL database(s).
  • Password: *******
  • Database: (you have to specify one database name)
Knowledgebase Article 80,648 views bookmark tags: php


Was this resource helpful?

Did this resolve your issue?


Please add any other comments or suggestions about this content:





Recommended Help Content

Configure the PHP Environment with php ini

How do I change the PHP environment for my site with php.ini?

Connecting to your MySQL DB from Dreamweaver

How can I connect to our MySQL database from Dreamweaver?

PHP Config

PHP vs PHP single php.ini vs PHP with FastCGI

Related Help Content

How to edit PHP Configuration

How to edit PHP Configuration --- VPS or Dedicated

PHP Configuration for Addon Domain

How can I adjust the php settings specifically for an Addon Domain?

Character sets in PHP

How to Set different character sets with PHP and HTML to display correctly.

MySQL Database Restore

How to Restore your MySQL Database?

FTP Setup using Dreamweaver MX

How do I connect and upload via FTP with Dreamweaver MX?

Publishing with DreamWeaver CS5

Learn how to publish the website you have created with Adobe Dreamweaver CS5

FTP Setup on Dreamweaver CC 2014

This article explains how to publish your site through FTP on Dreamweaver 2014

FTP Setup using Dreamweaver MX 2004

How do I connect and upload via FTP with Dreamweaver MX 2004?