How to set up MySQL connection with Dreamweaver
-
Open Dreamweaver
-
Click File > New
-
Choose Dynamic Page in left frame and then PHP (or any other type of dynamic page) in right frame.
-
Click Create (a new blank page will appear).
-
On the Tools window drop down the Application window and choose the Database tab.
-
Assuming a site has been created already you can skip option #1.
-
In the first 4 steps listed above a document type was created already, so you can skip option #2.
-
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. http://yourdomain.com/database/)
-
Click OK
-
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 www.yourdomain.com
--> 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
-
Click Test
-
If the test is successful click OK if the test in unsuccessful review the information provided in step #10.
Updated 4 months ago