318 Setup for Sample PHP Site
8. At the system command prompt, populate the new CafeTownsend
database in MySQL.
In Windows, use the following command:
cd \
cd Program Files\MySQL\MySQL Server 4.x\bin
mysql -uUser -pPassword CafeTownsend < insert.sql
On the Macintosh, use the following command:
mysql -uUser -pPassword CafeTownsend < ~/Documents/
insert.sql
This command uses the insert.sql file to add tables and records to the
CafeTownsend database you created in step 5.
After creating the MySQL database, create a database connection to it in
Dreamweaver.
Creating a database connection
The final step of the setup process is to create a connection to the database.
To create a database connection in Dreamweaver:
1. Open any PHP page in Dreamweaver and then open the Databases
panel (Window > Databases).
2. Click the Plus (+) button on the panel and select MySQL Connection
from the pop-up menu.
The MySQL Connection dialog box appears,
3. Enter connTownsend as the connection name.
4. In the MySQL Server text box, specify the computer hosting MySQL.
Enter an IP address or a server name. If MySQL is running on the same
computer as Dreamweaver, enter
localhost.
5. Enter your MySQL user name and password.
If you didn’t define a user name while configuring your MySQL
installation, enter root in the Username text box. If you don’t have a
password, leave the Password text box blank.
6. In the Database text box, enter CafeTownsend.
CafeTownsend is the name of the sample MySQL database you created
(see “Creating the MySQL database” on page 316).
