How do I set up the MySQL connection using 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.

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 Fast-name account's FTP login info.

14. Password must equal the Fast-name 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 localhost

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.

  • 361 Users Found This Useful
Was this answer helpful?

Related Articles

How do I connect to my MySQL database from a Perl CGI script?

Perl's DBI module provides an interface to MySQL databases for CGI scripts. A commented example...

How do I query a MySQL database from a PHP script?

Use the following outline to connect and begin querying the MySQL server from within your PHP...

How do I connect to MySQL with ASP?

This applies to Windows Hosting accounts only.You will need to use a DSNless connection which can...

Can I rename my database getting rid of the 'web-' part of the name?

Unfortunately this isn't possible as the convention is required for backing up the data on the...

What are the default / allowed privileges for MySQL databases?

By default on all MySQL databases the current privileges are given -SELECT, INSERT, UPDATE,...