MIS 561 MIS561 MIS/561 Lab 1 Installing MySQL Community Server and MySQL Workbench – DeVry Universit

Page 1

MIS 561 MIS561 MIS/561 Lab 1 Installing MySQL Community Server and MySQL Workbench – DeVry University

DOWNLOAD SOLUTION https://www.solvedcollegepapers.com/product/mis-561-mis561-mis-561-dev/ 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 Select Downloads tab on the top; Scroll down and under MySQL Community Edition select Community (GPL) Downloads; Category: Assignments Help Experts Tags: mis 561 lab 5, MIS 561 MIS561 MIS/561 Database administration and management - DeVry University, MIS 561mis 561, MIS561 Lab 1 Installing MySQL Community Server and MySQL Workbench, MIS561 Lab 2 Work with Dictionary and Create Relational Database, MIS561 Lab 3 Users Privileges and Roles, MIS561 Lab 4 Using Backups for Complete Recovery, MIS561 Lab 5 Optimizing query using EXPLAIN 

Description

Description


MIS561 Lab 1 Installing MySQL Community Server and MySQL Workbench – DeVry University 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-community5.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 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. 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. 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. Download Full Course Solution: PSY 216 PSY216 PSY/216 JOURNAL.docx – Shaina Denes Journal 1 https://www.solvedcollegepapers.com/product/psy-216-psy216-psy-216-joal-1/ The Myers-Briggs Type Indicator or MBTI is a psychological test for classifying personality types along four distinct categories including, introversion and extroversion, sensing and intuition, thinking and feeling and lastly, judging and perceiving. According to the test, every person has one dominant trait in each category. The theory is that every person will fall into one of the 16 personality types. This test can be used as a guide to help pinpoint personality traits, possible career paths, and provide some explanation for why and how we pick our friends, romantic partners and how we interact with the outside world as a whole. The other test that is used is The Big 5, this test has 5 main categories, where as the MyersBriggs has only 4. This test is shorter and less invasive than the Myers-Briggs, and has the acronym that gives a percentage of that letter found from the results of the few questions answered. “OCEAN”


standing for Open-Mindedness, conscientious, extraversion, agreeableness and negative emotionality. Download Full Course Solution: IT 210 IT210 IT/210 7-3 Final Project Submission Business Systems Analysis.docx https://www.solvedcollegepapers.com/product/it-210-it210-it-210-7-3-final-projectsubmission-business-systems-analysis-docx/ IT 210: Business Systems AnalysisIT 210 Final Introduction, Business Requirements, and Competitors and TechnologyGeoff LudwigSouthern New Hampshire University IT 210: Business Systems Analysis2ContentsIntroduction3Problem Statement13Two Technologies4Business Requirements5Objectives5Project Description5Technology Requirements6Competitors and Technology6Technology One [Intelligent Systems]6Technology Two [Cloud Computing]7Technology Solutions8Technology One [Intelligent Systems]8Technology Two [Cloud Computing]10Recommendations12Technology Solution12Overall Benefit13Security Considerations13Security Features13Third-Party Vendors152 Download Full Course Solution: BIOL 102 BIOL102 BIOL/102 : Principles of Human Biology – Liberty University https://www.solvedcollegepapers.com/product/biol-102-principles-of-human-biologyliberty-university/ 

week 5 ccrossword puzzle.docx

Liberty University

Principles of Human Biology

BIOL 102 – Fall 2012

Download Full Course Solution: CFDI-320 Week 3 Assignment – Another Day on the Job https://www.solvedcollegepapers.com/product/cfdi-320-week-3-assignment-anotherday-on-the-job/ CFDI-320 Week 3 Assignment - Another Day on the Job Week 3: Assignment - Another Day on the Job

You are a digital forensic examiner working at a firm and your next job is to conduct a digital forensic analysis on a forensic image created of a disk drive. You will need to use the department


report titled Week 3 – Assignment Report.docx download to conduct an examination on the forensic image week3assignment1.e01 located in our class directory CFDI-320 on the S:\ drive.


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.