Install the Sample Database

Installing the example database

Chapter 4 of SQL for MYSQL Developers describes how to install the example database. That description includes  explanations of how certain SQL statements work. This page contains a more concise description of the installation procedure. 

We assume that you have successfully installed MySQL and WinSQL. If you have already created a user, such as BOOKSQL, then start with step 4

Step 1: Start WinSQL and log on using the user name root with password root. 

Step 2: Create a new user called BOOKSQL with password BOOKSQLPW. Type in the following SQL statement:



Execute this statement by pushing the button with the green arrow. If the user is created, the following window appears:



Step 3: Assign BOOKSQL all the required privileges with the following statement, and execute the statement:

Stop WinSQL now.

Step 4: Start WinSQL and log on with user name BOOKSQL and password BOOKSQLPW:



Step 5: Create a new database called TENNIS using the CREATE DATABASE statement. Don't forget the execute the statement:



Step 6: Make TENNIS the current database through the USE statement:



Step 7: Download the file create_new_database. Open the file with, for example, Notepad. Copy all the statements from the file into WinSQL:



Execute all the statements by pushing the button with the green arrow. The example database will be ready after this.

Copyright (c) 2009 R20/Consultancy B.V.. All rights reserved.