Support / KnowledgeBase

 
Search the KnowledgeBase Search

Dreamweaver MX - PHP/MySQL Configuration

  • Applies to: All Service Types

  • Difficulty: Easy

  • Time needed: 5 minutes

  • Tools needed: None

 

NOTE:

This article will help you configure a PHP/MySQL testing server in Macromedia Dreamweaver.  Although this is Third-party software, and we do not support Third-party software configurations, we have created this article as a courtesy to our customers.


DETAILS:

  1. First, create a "Site" to hold your files. When creating the site, be sure to specify that you want to use the "PHP MySQL" server technology.
  2. Read the "Setting up a Dreamweaver site" section of the Dreamweaver Help File for more details about defining a site, or see our other Dreaweaver KnowledgeBase articles.
    1. Dreamweaver MX - Basic FTP instructions
    2. Dreamweaver MX Video Tutorials

  3. Make sure you set up a "Testing Server" using the same information as the remote server. The Server Model should be set to "PHP MySQL" and the Access menu should be set to "FTP" (see the articles above if you need help setting this part up).
  4. Once your site is set up, create a new PHP file in the site by selecting "Site" in the Site tab of the Files panel and pressing Ctrl+Shift+N.
  5. Rename your new file from untitled.php to something meaningful. Double-click the filename to open your new file. This file MUST be php, or you will not be able to access the database.
  6. Now it's time to set up a database connection. Click the "Databases" tab of the Application panel and then the button with the "+" on it.
  7. In the MySQL Connection dialog box that appears: Fill in the text boxes with the appropriate information. Your database server's host name (localhost) is entered in the "MySQL Server" box. The user name and password (Note that the username should be the same as your admin/FTP login and the MySQL password can be changed at any time from the WebControl panel, even without the old password) is entered in the User Name and Password boxes. The database name (yourdomain_tld) is entered in the "Database" box.


    • For (dv) and (ss) use localhost
    • For (gs) use internal-db.s#####.gridserver.com
    Click the Test button in the dialog box to make sure that the information you've entered works correctly.


See this KnowledgeBase article for (gs) connection info:

(gs) Why can't I connect to my MySQL database from PHP?

WARNING:

There is a known bug in Dreamweaver that does not allow for automatic table name discovery in databases with hyphens in the name. Since all of our (ss) Shared-Server databases include a hyphen in the name this affects all customers using Dreamweaver. The workaround is to manually specify table names in queries. Given a table name, Dreamweaver is able to query a database with a hyphen in it's name without a problem.

Revisions:

07-28-2009: Updated broken link
11-25-2008: Updated broken link

User Comments

No visitor comments posted. Post a comment

Fields marked with an asterisk(*) are required. Comment on this article

Fill out the form below if you would like to comment on this article.
 
 
 

(code is not case-sensitive)
 
Submit
 

User Opinions (5 Votes)

  • 80%
  • 20%
Was this article helpful?
Rate it
 
 

Continue