Install the Sample Database

Scheduled EventsEvent outlinesBooksWhitepapersWebinarsArticlesContact UsRick F van der Lans




[Home][Books][Introduction to SQL][Install sample Database]



Installing the Example Database


Chapter 4 of Introduction to SQL 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 IntroSQL_V4_create_new_database.txt. 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) 2017 R20/Consultancy B.V.. All rights reserved.