Adobe Dreamweaver CC 2015 - Manual (Page 560)

553
Dynamic sites, pages and web forms
Last updated 6/3/2015
2 Click the Plus (+) button on the panel, select MySQL Connection from the menu, and complete the dialog box.
• Enter a name for the new connection, without spaces or special characters.
• In the MySQL Server box, enter an IP address or a server name for the computer hosting MySQL. If MySQL is
running on the same computer as PHP, you can enter localhost.
• Enter your MySQL user name and password.
• In the Database box, enter the name of the database, or click Select and select the database from the list of MySQL
databases, and click Test.
Dreamweaver attempts to connect to the database. If the connection fails, double-check the server name, user name,
and password. If the connection still fails, check the settings for the testing folder Dreamweaver uses to process
dynamic pages.
Dreamweaver makes a best guess at auto-populating the value for the URL prefix in the Testing Server category of
the Site Definition dialog box, but sometimes you will have to adjust the URL prefix to get your connection to work.
Make sure that the URL prefix is the URL that users type in their browsers to open the web application, minus the
file name (or start page) of the application.
3 Click OK.
Note: If you encounter the error message “Client does not support authentication protocol requested. Consider
upgrading MySQL client” when testing a PHP database connection to MySQL 4.1, see .
Edit or delete a database connection
When you create a database connection, Dreamweaver stores the connection information in an include file in the
Connections subfolder in the site’s local root folder. You can edit or delete the connection information in the file
manually or as follows.
Edit a connection
1 Open a PHP page in Dreamweaver, and then open the Databases panel (Window > Databases).
2 Right-click (Windows) or Control-click (Macintosh) the connection and select Edit Connection from the menu.
3 Edit the connection information and click OK.
Dreamweaver updates the include file, which updates all the pages in the site that use the connection.
Delete a connection
1 Open a PHP page in Dreamweaver, and then open the Databases panel (Window > Databases).
2 Right-click (Windows) or Control-click (Macintosh) the connection and select Delete Connection from the menu.
3 In the dialog box that appears, confirm that you want to delete the connection.
Note: To avoid getting errors after deleting a connection, update every recordset that uses the old connection by double-
clicking the name of the recordset in the Bindings panel and selecting a new connection in the Recordset dialog box.
More Help topics