FastDomain 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 FastDomain 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 89,219 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 do I change the PHP environment for my site with php.ini?
Knowledgebase Article 590,894 views tags: configuration php server

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

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

Related Help Content

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

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

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

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

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

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

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

This article will outline which PHP PEAR Packages are installed and how you can install additional PHP PEAR Packages.
Knowledgebase Article 100,348 views tags: package pear php