There was a problem loading the comments.

How do I set up the MySQL connection using Dreamweaver?

Support Portal  »  Knowledgebase  »  Viewing Article

  Print
Before any of these steps are carried out you will need to enable remove connections to the db via the option in your hosting control panel, click here for our guide to configuring.

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.

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

10. Access should equal FTP (this information is pertaining to how Dreamweaver will upload it's pages).

11. FTP host must equal the users domain name

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

13. Login must equal the Eco Web Hosting account's FTP login info.

14. Password must equal the Eco Web Hosting account's FTP pass.

15. URL prefix must be the complete URL (i.e. http://yourdomain.com/)

16. Click "OK"

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

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

19. MySQL Server Name must equal the server listed on the MySQL Database page in your hosting control panel

20. User name must user name of the database that you set up

21. Password must equal the password used to access the MySQL database (as you configured it)

22. Database must equal the user name user name as in (20) above

23. Click Test

24. If the test is successful click "OK" if the test in unsuccessful review the information provided in step #17.

Share via
Did you find this article useful?  

Related Articles

© Eco Web Hosting