How do I set up a MySQL connection in Dreamweaver?

In Dreamweaver, you can create dynamic pages, which use PHP or other scripting languages to connect to a MySQL database to create pages with dynamic content.

In order to create these pages, you need to first connect Dreamweaver to the MySQL database.

To connect Dreamweaver:

1. Open Dreamweaver
2. Open a new file
3. Select ‘Dynamic Page’ as the type, and then ‘PHP’ or another language
4. Click ‘Create’
5. Your new dynamic page will appear as a blank page
6. In ‘Tools’, select ‘Application’, then ‘Database’
7. If you have already created a site, skip the first option
8. Since you have already created the document type, skip the second option
9. Click the ‘Testing Server’ link in the third option
10. Select the server model that matches up to the language you chose in Step 3 (for example, ‘PHP MySQL’)
11. Select ‘FTP’ for access, and enter in the FTP host for your domain name
12. Enter in the directory you would like to upload the files to under ‘Host Directory’
13. Enter in your FTP login
14. Enter in your FTP password
15. Enter in the full URL for your site under URL Prefix (for example, http://your-domain.com)
16. Click ‘OK’
17. In the ‘Databases’ tab, click the + icon at the top of the window and choose ‘MySQL Connection’
18. Your connection name can be anything, as this is only a descriptive name for you to recognise the connection
19. Enter in ‘localhost’ for the MySQL Server Name
20. Enter in the database’s user name
21. Enter in the database’s user name’s password
22. Under ‘Database’, enter in the database’s user name again
23. Click ‘Test’
24. If the test is successful, click ‘OK’
25. The connection is now available to create dynamic pages