Dreamweaver MX Configuration for PHP and MySQL
If you are using assistive technology and are unable to read any part of the HostMonster website, or otherwise have difficulties using the HostMonster website, please call 866-573-HOST and our customer service team will assist you.
Skip to main content

HostMonster 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 HostMonster 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 166,530 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

How can I connect to our MySQL database from Dreamweaver?
Knowledgebase Article 272,824 views tags: connecting database dream mysql weaver

How do I change the PHP environment for my site with php.ini?
Knowledgebase Article 810,473 views tags: configuration ini php server

How to edit PHP Configuration --- VPS or Dedicated
Knowledgebase Article 183,687 views tags: dedicated php root vps whm

Related Help Content

How can I adjust the php settings specifically for an Addon Domain?
Knowledgebase Article 332,482 views tags: domain php

How to Set different character sets with PHP and HTML to display correctly.
Knowledgebase Article 216,248 views tags: arabic character chinese collation japanese language languages mysql php phpmyadmin sets

How to Restore your MySQL Database?
Knowledgebase Article 385,317 views tags: admin database mysql php phpmyadmin restore

How do I connect and upload via FTP with Dreamweaver MX?
Knowledgebase Article 259,721 views tags: dreamweaver ftp

Connecting and uploading via FTP with Dreamweaver CS5
Knowledgebase Article 499,044 views tags: dreamweaver ftp

Learn how to publish the website you have created with Adobe Dreamweaver CS5
Video "How-to" Tutorial 311,682 views tags: dreamweaver

This article explains how to publish your site through FTP on Dreamweaver 2014
Knowledgebase Article 154,022 views tags: cc dreamweaver ftp

How do I connect and upload via FTP with Dreamweaver MX 2004?
Knowledgebase Article 245,233 views tags: dreamweaver ftp

This site utilizes JavaScript to function correctly. Looks like it's disabled on your browser. Please enable it for your best experience.

For instructions on enabling JavaScript, click here