How to set up MySQL connection with Dreamweaver

  1. Open Dreamweaver

  2. Click File > New

  3. Choose Dynamic Page in left frame and then PHP (or any other type of dynamic page) in right frame.

  4. Click Create (a new blank page will appear).

  5. On the Tools window drop down the Application window and choose the Database tab.

  6. Assuming a site has been created already you can skip option #1.

  7. In the first 4 steps listed above a document type was created already, so you can skip option #2.

  8. Click on the link that says testing server in option #3.

--> Server model should equal PHP MySQL (this is the dynamic page chosen was equal to PHP).

--> Access should equal FTP (this information is pertaining to how Dreamweaver will upload its pages).

--> FTP host must equal the users domain name

--> Host directory must equal the directory to where the user would like his/her pages to be uploaded to.

--> Login must equal the Mochahost accounts FTP login info.

--> Password must equal the Mochahost accounts FTP pass.

--> URL prefix must be the complete URL (i.e.

  1. Click OK

  2. Under the Databases tab in the application window click on the + symbol at the top of the window and choose MySQL Connection

--> Connection name can be anything (this is only a descriptive name for the user to recognize the specified connection).

--> MySQL Server Name must equal

--> User name must equal the FTP user name

--> Password must equal the password used to access the MySQL database (this is usually the FTP password)

--> Database must equal the user name used to access the Mochahost account

  1. Click Test

  2. If the test is successful click OK if the test in unsuccessful review the information provided in step #10.