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 69,126 views bookmark tags: php (updated 2109 days ago)


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? (updated 1134 days ago)
Knowledgebase Article 100,214 views tags: connecting database dream mysql weaver

PHP vs PHP single php.ini vs PHP with FastCGI (updated 1172 days ago)
Knowledgebase Article 146,306 views tags: configuration php server

How to edit PHP Configuration --- VPS or Dedicated (updated 406 days ago)
Knowledgebase Article 7,822 views tags: dedicated php root vps whm

Related Help Content

How do I change the PHP environment for my site with php.ini? (updated 462 days ago)
Knowledgebase Article 379,986 views tags: configuration php server

How can I adjust the php settings specifically for an Addon Domain? (updated 1110 days ago)
Knowledgebase Article 110,498 views tags: domain php

HostMonster offers numerous email options. (updated 574 days ago)
Knowledgebase Article 137,809 views tags: basic configuration configure email mail setup

How to Set different character sets with PHP and HTML to display correctly. (updated 2092 days ago)
Knowledgebase Article 65,458 views tags: character language mysql php phpmyadmin sets

How to Restore your MySQL Database? (updated 1117 days ago)
Knowledgebase Article 156,231 views tags: admin database mysql php phpmyadmin restore

I'm trying to configure an application (phpList) and it requires that I enter (in config.php) a username and password for a POP3 account to handle bounces. I keep getting a POP3 error and it can't log (updated 2140 days ago)
Knowledgebase Article 71,928 views tags: list mail php phplist

How do I connect and upload via FTP with Dreamweaver MX? (updated 2125 days ago)
Knowledgebase Article 98,880 views tags: dreamweaver ftp

Learn how to publish the website you have created with Adobe Dreamweaver CS5 (updated 1134 days ago)
Video "How-to" Tutorial 163,019 views tags: dreamweaver