MySQL Setup for Self-Paced Classes

1. Windows 10 or later or Mac: OS X Mountain Lion (version 10.8) or later
2. MySQL Community Server - Free edition of MySQL RDBMS.
3. MySQL Workbench - The client interface for connecting to MySQL.

Windows and Mac Users

Creating the Webucator Folder

The first step to setting up for your course is to create the folder in which you will store your class files: Create a new folder named Webucator wherever you want, but make sure you remember where it is.

Getting the Class Files for Introduction to SQL

Download the Introduction to SQL class files and unzip them into the Webucator folder. This will create a folder called ClassFiles.

Instructions for Windows Users

(Instructions for Mac users are below)

Install the MySQL Community Server

1. Download the latest version of MySQL Community Server. If you already have an older version installed, it should work fine for this class.
   1. It should pre-select your operating system. Click the Go to Download Page button:
      
      
   2. Click the Download button for the mysql-installer-web-community file:
      
      
   3. You will be offered the opportunity to create an account. You don't need to do this. Click the No thanks, just start my download link to download the installer. You can download it wherever you like.
2. Run the installer by opening the downloaded file:
   
   
3. Choosing a Setup Type: Select Custom as click Next >.
4. Select Product and Features: Select MySQL Server and MySQL Workbench and then click Next >:
   
   
5. Installation: This shows what will be installed. 
   
   
   
   Click the Execute button at the bottom.
6. Once the products are installed, the Status will change to Complete. Click Next >.
   
   
7. Continue to click Next > until you get to Accounts and Roles. Enter a strong password (don't forget it!) and click Next >.
   
   
8. Continue to click Next > until you get to Apply Configuration. Click Execute:
9. Product Configuration: Click Next >.
10. Installation Complete: Check the box to start MySQL Workbench and click Next >.

Install the Northwind Database

1. Open MySQL Workbench if it's not open already and click local under MySQL Connections:
   
   
2. Enter your password:
   
   
3. Click the second icon from the left to open a SQL script:
   
   
4. Open Webucator\ClassFiles\setup\Northwind-MySQL.sql.
5. Execute the script by clicking on the lightning bolt:
   
   
6. Under Schemas on the left, click the refresh icon:
   
   
7. The Northwind database should now show up:
   
   
8. Select New Query Tab from the File menu:
   
   
9. In the New Query Tab, enter:
   
   SELECT * FROM Employees;
   
   And press the lightning bolt to run the query. You should get a result set like the one below:

Instructions for Mac Users

Install the MySQL Community Server

1. Download the latest version of MySQL Community Server. If you already have an older version installed, it should work fine for this class.
   1. It should pre-select your operating system. Click the Download button for the DMG Archive:
      
      
   2. You will be offered the opportunity to create an account. You don't need to do this. Click the No thanks, just start my download link to download the installer. You can download it wherever you like.
2. Run the installer by opening the downloaded DMG file:
   
   
3. Click through the installer accepting the defaults. When you get to the Password Encryption option, choose Use Strong Password Encryption:
   
   
4. Enter a strong password (don't forget it), leave Start MySQL Server once the installation is complete checked, and click Finish:
   
   
5. You can then move the installer to Trash.

Install MySQL Workbench

1. Download MySQL Workbench.
   1. It should pre-select your operating system. Click the Download button for the DMG Archive:
      
      
   2. You will be offered the opportunity to create an account. You don't need to do this. Click the No thanks, just start my download link to download the installer. You can download it wherever you like.
2. Run the installer by opening the downloaded DMG file and then dragging the resulting MySQLWorkbench.app into the Applications folder:
   
   

Install the Northwind Database

1. Press Cmd+Space and enter MySQLWorkbench, then doubleclick MySQLWorkbench.app to open it.
2. Click Local Instance 3306 under MySQL Connections:
   
   
3. Enter your password:
   
   
4. Click the second icon from the left to open a SQL script:
   
   
5. Open Webucator\ClassFiles\setup\Northwind-MySQL.sql.
6. Execute the script by clicking on the lightning bolt:
   
   
7. Under Schemas on the left, click the refresh icon:
   
   
8. The Northwind database should now show up:
   
   
9. Select New Query Tab from the File menu:
10. In the new Query tab, enter:
    
    SELECT * FROM Employees;
    
    Press the lightning bolt to run the query. You should get a result set like the one below: