[NEW SOLN] MIS561 LAB 1 INSTALLING MYSQL COMMUNITY SERVER AND MYSQL WORKBENCH

[SOLVED] MIS561 LAB 1 INSTALLING MYSQL COMMUNITY SERVER AND MYSQL WORKBENCH: Part 1: Installing MySQL Installer and MySQL Workbench

1. 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
2. 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 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 wizard for installation.
      – Scroll down to select platform:Select Platform: Microsoft Windows
      Windows (x86, 32-bit), MSI Installer, click Download button
   4. The Begin Your Download window come 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.[SOLVED] MIS561 LAB 1 INSTALLING MYSQL COMMUNITY SERVER AND MYSQL WORKBENCH:
   10. Window Check Requirements – follow instructions on the window. Click Next.
   11. Click Execute to start downloading process. Installer shows the status of installation (upgrade) for each product. Click Next.
   12. Product Configuration screen appears and shows products to be installed using Wizard. Click Next.
   13. Type and Networking screen appears – Click Next;
   14. Accounts & Roles screen – to set up MySQL password. Type 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. 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.

[SOLVED] MIS561 LAB 1 INSTALLING MYSQL COMMUNITY SERVER AND MYSQL WORKBENCH: Part 2: Installing MySQL Server
To start, go to the MySQL official site: www.mySQL.com

1. Select 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), Save a file;
7. Close the download window;
8. Close your browser;
9. Once the download is complete, you will see a new icon on Desktop – MySQL Installer;
10. Click on a new icon on Desktop – MySQL Installer;
11. Run it;
12. Installation Wizard comes up. Click Next;
13. On a Please select a set-up type, choose Custom and click Next;
14. On new screen, choose how the feature will be installed – show the directory: on the C: drive and under the webdev directory, create new folder mysql and click OK.
    C:\webdev\mysql\
15. Click Next. Hit Install – installation starts, Status bar shows the progress;
16. MySQL provides an additional information available for fee, click Next;
17. On screen Wizard completed, uncheck Register MySQL server now and check Configure MySQL server now;
18. Select Finish;
19. If you are asked about the permission to install program, click Yes;
20. On the MySQL Server Instance Configuration Wizard, click Next;
21. Please select a configuration type Detailed configuration and click Next;
22. On the next page, uncheck the Developer machine and choose Server machine. Click Next;
23. For the database usage, choose Multifunctional Database. Click Next;
24. For the InnoDB datafile, choose C: drive. Click Next;
25. 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;
26. For the Networking option, check Enable TCP/IP Networking with default port 3306; also leave checked Enable Strict Mode. Click Next;
27. For the default character set, choose Standard Character set; hit Next;
28. For the Windows option, check Install as a Windows server; it will start MySQL server when 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 password, click Next;
31. Execute your configurations;
32. When complete, click Finish.

[SOLVED] MIS561 LAB 1 INSTALLING MYSQL COMMUNITY SERVER AND MYSQL WORKBENCH: Deliverables
Your assignment will be graded based on the following:

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.

You May Also Like

[NEW SOLN] MIS561 LAB 2 WORK WITH DICTIONARY AND CREATE RELATIONAL DATABASE

$11.99

[SOLVED] MIS561 LAB 2 WORK WITH DICTIONARY AND CREATE RELATIONAL DATABASE: In this lab, you will prepare a Data Dictionary based on the list of elements. Also, your task will be determined the tables, their relationships, primary and foreign keys. Based on this analysis, you will create Database Schema, relational tables, Entity –Relational Diagram (ERD), establish connection to your local MySQL Server, create physical database and insert data to the tables.

By: GradeMeritsadmin

[NEW SOLN] MIS561 LAB 3 USERS PRIVILEGES AND ROLES

$11.99

[SOLVED] MIS561 LAB 3 USERS PRIVILEGES AND ROLES: MySQL, like many other databases, uses the combination of specific user definitions, privileges, and roles to control access to the data in the database. In turn, it provides various layers of security. When the database is first created, there are several users created for the purpose of not only installing various components of the database, but also to manage and administer the database functionality.

By: GradeMeritsadmin

[NEW SOLN] MIS561 LAB 4 USING BACKUPS FOR COMPLETE RECOVERY

$11.99

[SOLVED] MIS561 LAB 4 USING BACKUPS FOR COMPLETE RECOVERY: Successful database recovery relies on the database being backed. This is what enables the database to recover data that were lost due to a media failure, loss of power, or any other type of disaster. Each time the online line redoes logs filled up in a log group, the DBMS issues a log switch that will move the log writer process from the current redo log group to the next one in line.

By: GradeMeritsadmin