Setting the MySQL Connection dialog box options

The purpose of this dialog box is to create a database connection for a PHP application.

Make sure the MySQL server is started before completing this dialog box.

To create a database connection:

1. Enter a name for the new connection.

   NOTE

   Do not use any spaces or special characters in the name.

2. In the MySQL Server box, specify the computer hosting MySQL.

   Enter an IP address or a server name. If MySQL is running on the same computer as PHP, you can enter localhost.

3. Enter your MySQL user name and password.
4. In the Database box, enter the name of the database, or click Select and select the database from the list of MySQL databases.
5. 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 folder Dreamweaver uses to process dynamic pages (see Specifying where dynamic pages can be processed).

6. Click OK.

   The new connection appears in the Databases panel.

   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 Troubleshooting MySQL error messages.

Related topics

• Connecting to a database