By Liam Grealy

1

• By Liam Grealy

2
MySQL Background

• MySQL is named after co-founder Monty Widenius's
  daughter, My.
• First released internally May, 1995
• First production release was January, 2001
• Sun Microsystems acquired MySQL on 26 February,
  2008
• Dolphin in the logo named Sakila

3
Features

• Understands standards based SQL
• Runs server side (Good Hardware, Fast Data)
• Open Source (Free) database
• Runs on either Windows or UNIX Platform
• Recommended Hardware
• Pentium V Processor
• 128MB RAM (32MB Required)

4
Using MySQL With DDC
5
First Locate ddc In Scratch
Note It is located at K\Full Time\mySQL
6
Move Full ddc File To SQL Data Folder
Note Place Entire ddc Folder In C\Program
Files\MySQL\MySQL Server 5.0\data
7
Open MySQL Query Browser
Note Password At School Is admin Recommended
Fill In Default Scheme And Will Auto Popup
Correct Database Inside Query Browser
8
Welcome To MySQL
Insert Your Queries Here Hit Execute To Run Them
Shows An Overview Of Your ddc
Schemata/Database (same thing)
9
Oracle To MySQL

• PROMPT in MySQL must be written
• SELECT abc (abc text want to
  display)
• SQL Commands Taught So Far In Class Treated
• The Same As Oracle ie. SELECT, INSERT, UPDATE,
• DELETE, etc.

10
Syntax Help Available
11
A Simple SELECT Statement
12
Using Command Prompt
Remember Password At School Is admin
You MUST Tell MySQL To Use ddc (Acts Like A
Connection String)
13
Using Command Prompt
14
Installing MySQL At Home
15
Go To MySQL Home Page
1

• www.mysql.com
• Click On Developer Zone
• In Developer Zone Click Downloads

2
16
Click To Download MySQLCommunity Server
17
Pick Your Operating System
Note More available space restrictions forced a
cutoff
18
Pick Your Version (Via Mirror Link)
19
Oops
You know you really should have an account to use
MySQL (((But you dont have to)))
20
If Choose To Signup Is Real Quick
21
There Is A Waterloo Mirror
22
Save The Install File To Wherever Convenient
23
Run The Download File

• Select Typical Install
• When Install Is Complete Below Image Will Show

Proceed Then Select Configure The MySQL Server
Now
24
Select Standard Configuration
25
Select Both Checkboxes
26
Set Root Password
Note For Slide Continuity It Is Assumed Used
Password admin
27
If Successful After Execute Get Following Box
28
Click To Download MySQLGUI Tools
To Obtain The GUI Interface Tools You Must
Revisit www.mySQL.com Downloads Section And
Click MySQL GUI Tools No Server Setup Will Be
Required Just Drag/Drop The File It Provides
Into Your C And Create Shortcuts
29
Congratulations
You Are Now Done
30
Sources

• http//www.mysql.com/
• http//www.tutorialsweb.com/sql/mysql.htmIntroduc
  tion
• http//en.wikipedia.org/wiki/MySQL