Basic SQL - Learning MySQL - page 136

artist_id

Artist

artist_name

1

Compiles

N

album_id

1

Contains Album

track_id album_name

N

track_name Track

1

time

WasPlayedAt

N

played Played

Figure 5-1. The ER diagram of the music database

To begin exploring the music database, connect to the MySQL monitor using the
root MySQL account. For Mac OS X or Linux, run a terminal program, and in the
terminal window type:
$ mysql --user=root --password= the_mysql_root_password
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 5.0.22

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

For Windows, click on the Start menu, then on the Run option, and then type cmd and
press Enter. In the DOS or command window, type:
C:\> mysql --user=root --password= the_mysql_root_password
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 5.0.22

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
If you find that the monitor doesn't start, check the instructions in “Error Message
About MySQL Executable Programs Not Being Found or Recognized” in Chapter 2 to
see how to run it.