DeVry MIS 561 iLab 1 Installing MySQL Community Server and MySQL Workbench

Part 1: Installing MySQL Installer and MySQL Workbench

• Choose which distribution to install.
  Several versions of MySQL are available, and most are available in several distribution formats. We choose a production (stable) release:
  MySQL 5.6: Latest General Availability (Production) release
• How to Install, Configure, and Verify a MySQL Workbench on Windows 7.
  To start, go to the MySQL Official site: www.mySQL.com

1. Select the Downloads tab on the top;
2. Scroll down and under MySQL Community Edition select Community (GPL) Downloads;
3. Choose MySQL on Windows (Installer & Tools) and click ‘DOWNLOAD’
   (Current Generally Available Release 5.6.21 or higher)
   – Select MySQL Installer which provides a wizard for installation.
   – Scroll down to select platform:
   Select Platform: Microsoft Windows
   Windows (x86, 32-bit), MSI Installer, click the Download button
4. The Begin Your Download window comes up,
5. Bypass Begin Your Download form, on the bottom of the page, choose No thank you, just take me to the downloads,
6. Appears Panel with Do you want to run or save MySQL-installer-web-community-5.6.22.msi from cdn.mysql.com? Choose Run.
7. Message Do you want to allow the following program to install software on this computer? Answer Yes.
8. Accept License Agreement, click Next.
9. Window Choosing a Setup Type.
   – Check Full radio button to install all included MySQL products and features; click Next.
10. Window Check Requirements – follow instructions on the window. Click Next.
11. Click Execute to start the downloading process. The installer shows the status of installation (upgrade) for each product. Click Next.
12. Product Configuration screen appears and shows products to be installed using the Wizard. Click Next.
13. Type and Networking screen appears – Click Next;
14. Accounts & Roles screen – to set up MySQL password. Type the password and note it. Click Next.
15. Windows Services screen – choose Standard System account; Click Next.
16. Apply Server configuration screen – click Execute.
17. After processing, press Finish.
18. Product Configuration screen – Click Next.
19. Connect to Server screen – click Check.
20. Message connection successful.
21. Click Next.
22. Screen Apply server configuration – Click Execute.
23. The installer shows progress.
24. When complete, click Finish.
25. Product Configuration screen – Click Next.
26. Installation complete message will notify about installation completion.
27. Click Finish.

Play Video

Name: Jennifer Lucas
Status: Online ⬤
Classes Taken: 3878
Ratings: ⭐⭐⭐⭐⭐

Hire Me

STATUS

Part 2: Installing MySQL Server

To start, go to the MySQL official site: www.mySQL.com

1. Select the Downloads option;
   Under MySQL community edition, select MySQL Community Server; click DOWNLOAD;
2. Select Platform: Microsoft Windows
3. Choose Other downloads: Windows 32-bit or 64-bit and press Download. To verify your OS parameters, go to Start, Control panel, System and Security, System will show the System type;
4. The Registration window comes up, click register. As soon as you are registered, you will be able to log in.
5. Bypass form. On the bottom of the page, choose No thank you, just take me to the downloads.
6. Select the nearest location (example: North America’ option, Hurricane Electric, choose ‘HTTP’ option there),
7. Save a file;
8. Close the download window;
9. Close your browser;
10. Once the download is complete, you will see a new icon on Desktop – MySQL Installer;
11. Click on a new icon on Desktop – MySQL Installer;
12. Run it;
13. Installation Wizard comes up. Click Next;
14. On a Please select a set-up type, choose Custom and click Next;
15. On the new screen, choose how the feature will be installed – show the directory: on the C: drive and under the web dev directory, create new folder MySQL and click OK.
    C:\webdev\mysql\
16. Click Next. Hit Install – installation starts, Status bar shows the progress;
17. MySQL provides a piece of additional information available for free, click Next;
18. On-screen Wizard completed, uncheck Register MySQL server now and check Configure MySQL server now;
19. Select Finish;
20. If you are asked about the permission to install the program, click Yes;
21. On the MySQL Server Instance Configuration Wizard, click Next;
22. Please select a configuration type Detailed configuration and click Next;
23. On the next page, uncheck the Developer machine and choose the Server machine. Click Next;
24. For the database usage, choose Multifunctional Database. Click Next;
25. For the InnoDB datafile, choose C: drive. Click Next;
26. For the concurrent connections to the server (how many users may work simultaneously to MySQL server), choose default Decision Support (DSS)/OLAP for 20 users;
27. For the Networking option, check Enable TCP/IP Networking with default port 3306; also leave checked Enable Strict Mode. Click Next;
28. For the default character set, choose Standard Character set; hit Next;
    For the Windows option, check to Install as a Windows server; it will start MySQL server when a computer is up;
29. Also, select Include the Directory to Windows PATH. So we can work from command path; click Next;
30. To select security options, create a password, click Next;
31. Execute your configurations;
32. When complete, click Finish.

Deliverables

Your assignment will be graded based on the following:

Assignment Step Description Points

Step 1 Install MYSQL Installer 10
Step 2 Install MySQL Workbench 15
Step 3 Install MySQL Community Server 15

Total Lab Points 40

Steps 1, 2, and 3 will have you create a single Word document for this week’s iLab. Include the screenshots of the beginning and the last steps of installation. Add your feedback (issues, questions, errors) for the installations. Please be sure to label your document and include your name and course number in the heading. Save your document as yourname_iLab_1.docx.