To create a database connection:

1.

Create the sample MySQL database using the SQL script (see 

 Creating 

the MySQL database  on page 316

).

2.

Create the connection in Dreamweaver (see 

 Creating a database 

connection  on page 318

).

Creating the MySQL database

The sample files for Dreamweaver include a SQL script capable of creating 

and populating a sample MySQL database.

Before starting, make sure MySQL is installed and configured on your 

local or remote computer. Download the latest version from the MySQL 

website at 

http://dev.mysql.com/downloads/

. For development purposes, 

download and install the Windows Essentials version of the MySQL 

database server.

To create the sample MySQL database:

1.

Copy the SQL script file, insert.sql, to an appropriate folder on the 

computer that has MySQL installed.

If you installed Dreamweaver to its default location, the path to the 

script file is as follows:

I

C:\Program 

Files\Macromedia\Dreamweaver 8\Tutorial_assets\cafe_townsend\

data\insert.sql (Windows)

I

/Applications/Macromedia Dreamweaver 8/Tutorial_assets/

cafe_townsend/data/insert.sql (Macintosh)

If the computer running MySQL is a Windows computer, copy the 

insert.sql script to Program Files\MySQL\MySQL Server 4.x\bin. If 

the computer running MySQL is a Macintosh, copy the insert.sql 

script to your Documents folder in your home folder.

2.

On the computer that has MySQL installed, start the MySQL 

Command Line Client (Windows) or the Terminal (Macintosh).

I

In Windows, start the MySQL Command Line Client by selecting 

Start > MySQL > MySQL Server 4.x > MySQL Command Line 

Client.

I

On the Macintosh, start the Terminal by going to the Applications 

folder, opening the Utilities folder, and double clicking Terminal.

316 Setup for Sample PHP Site