Just Host 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 Just Host 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 82,555 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 551,017 views tags: configuration php server

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

PHP vs PHP single php.ini vs PHP with FastCGI
Knowledgebase Article 222,307 views tags: configuration php server

Related Help Content

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

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

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

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

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

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

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

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