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 68,242 views bookmark tags: php (updated 2034 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 1059 days ago)
Knowledgebase Article 97,699 views tags: connecting database dream mysql weaver

PHP vs PHP single php.ini vs PHP with FastCGI (updated 1097 days ago)
Knowledgebase Article 140,958 views tags: configuration php server

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

Related Help Content

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

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

HostMonster offers numerous email options. (updated 499 days ago)
Knowledgebase Article 134,536 views tags: basic configuration configure email mail setup

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

How to Restore your MySQL Database? (updated 1042 days ago)
Knowledgebase Article 153,031 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 2065 days ago)
Knowledgebase Article 70,492 views tags: list mail php phplist

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

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