ITS538: Database Systems

Installing MySQL I T S 5 3 8 : D ATA B A S E S Y S T E M S

ITS 538 Database Systems

Course Project Ph1

Miguel Buleje, PhD [email protected]

MySQL- Intro

• MySQL is a an open source DBMS by Oracle with a Community Version free to down load. I will demonstrate in this presentation how to install the latest version for MySQL at this time that is V.8, on a 64 bit version of WIN 10.

• Components Required to complete your Projects:

• MySQL Server

• MySQL Workbench

• I will present in this instructional document a series of screen shoots to walk you through the installation process. We are going to use the Installer utility to install the latest MySQL Community Server and Workbench.

Step 1: Visit the URL below (dev.mysql.com)

Step 1: Navigate to “Downloads”

Step 3: Select “MySQL Community Server”

Step 4: MySQL Installer – “Go to Download Page”

Step 5: Select OS AND Download Smaller File

Step 6: Start Download (follow the option below)

Step 7: Open Downloaded File

Step 8: Chose Setup Type – “Custom”

Step 9 (a): Select Products and Features (Select MySQL Server V8.0.20 x64 & Workbench V8.0.20 – x64 for bit system)

Step 9 (b): Select Products and Features (Select MySQL Server V8.0.20 x64 & Workbench V8.0.20 – x64 for bit system)

Step 9 (c): Select Products and Features (Select MySQL Server V8.0.20 x64 & Workbench V8.0.20 – x64 for bit system)

Step 10: Initiate Installation – “Execute”

Step 11: Complete Installation – “Next”

Step 12: Product Configuration – “Next”

Step 13: High Availability (Standalone MySQL Server/ Classic MySQL Replication)

Step 14: Type and Networking Config. Type: Development Computer Port: XXXX (Must keep record for this number. Please write down) All other settings intact.

Step 15: Authentication Method (Use Legacy Authentication Method)

Step 16: Accounts and Roles (Write down your Root Password – very important)

Step 17: Windows Service (Configure MySQL Server as a Windows Service)

Step 18: Apply Configuration – “Execute”

Step 19: Apply Configuration – “Finish”

Step 20: Product Configuration – “Next”

Step 21: Apply Configuration – “Finish”

Step 22: Installation Complete – “Finish”

Step 23: Welcome to MySQL Workbench (Use authentication / credentials you created)

Step 24: SQL Workbench – READY!