To begin, we need to create and populate
this database. For the example, I??™ll be using MySQL, a popular open-source
database application.
This chapter covers what you need to know to create the database but assumes
that you have access to a MySQL installation. I??™ll demonstrate the steps in this
chapter using two di?¬? erent interfaces: the command-line mysql client and
the Web-based phpMyAdmin. If you have any questions or problems with
this chapter??™s instructions, see my book MySQL, Second Edition: Visual
QuickStart Guide (ISBN 0-321-37573-4) or search the Web.
1. creating the database
1
access MySQL
If you??™re running MySQL on your own computer, or have command-line
access to your server, log into the mysql client. You??™ll need to enter a
username and password combination. These values must already be
established in MySQL in order to work. (See extra bits on page 9.)
If you??™re running MySQL on a remote server, or you just prefer not to go
command-line, use phpMyAdmin in a Web browser. It must already be
preconfi gured to access MySQL.
2 creating the database
make the database
1 On the command line, using the mysql client, type CREATE DATABASE
ajax, followed by a semicolon (;), and press Enter or Return.
Pages:
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26