Information Systems MIS 3306 Assignment

MIS3306 Module 8-1 Exercise

MySQL Installation Guide for Windows

Required for Grading (Type Your Name Below):

I am (type your full name) and I complete this assignment following the UHD academic integrity policy.

Installation Guide (Require your answer at the end!):

1. You are going to install MySQL Community (GPL). To download the installer, connect to https://dev.mysql.com/downloads/installer/ . You may use the newest version, or click the Archives tab and find an earlier version (when you are using an earlier Windows).

· Choose the bigger download for the whole package. Choose the smaller download if you want a faster download. You will need the internet during installation. As we will only install part of the whole package, this is recommended.

2. In the next account sign up screen, click “ No thanks, just start my download.”

3. Choose Custom installation.

4. From the left panel, find MySQL Server and MySQL Workbench and move them to the right panel.

· MySQL Server is the database server that hosts the database.

· MySQL Workbench is the client-side GUI application that you will use to manage the database.

5. The installer will check software requirements (it needs other software to run). Click on “MySQL Server” and click “Execute”. The installer will install the required Microsoft Visual C++ Redistributable package. Only after the green check marks ü appear for both products, you can click Next> to proceed.

6. Go ahead to install the required software package (Microsoft Visual C++ Redistributable).

7. After the requirement check is completed (have green check marks), you can click “Next” to continue.

8. Choose “Standalone MySQL Server” because we are not going to use a database cluster.

9. After the installation, you should configure your server through the steps here:

a. Click WindowsMySQLMySQL Installer Community

b. In the next “MySQL Installer” window, highlight MySQL Server and click Reconfigure. Then you can continue the configuration.

10. In the following Type and Networking screen, use the default configuration. They should be:

· Development Computer: This configuration uses a minimal amount of the resources to MySQL Service.

· TCP/IP Port 3306: This configures how the MySQL Workbench connects to the MySQL Server.

11. For the authentication method, choose the default “Use Strong Password Encryption for Authentication”.

12. Input the password for “root” user. This is not your computer password. MySQL will create an administration account name “root” and is now asking you to set the root password. Remember/write down the password because it will be very, very difficult to reset it.

· Reset MySQL root password: https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html

13. Use the default configuration for Windows service. Make sure MySQL Server will start at Windows system startup.

14. When the installation complete, start MySQL Workbench.

15. Click “Local Instance” and input the root password that you typed earlier. You are now using MySQL Workbench (client-side application) to connect to MySQL Server.

16. In the following MySQL Workbench screen, you will see your server is running. Type your full name in the query editor.

· Alternatively, you may use your Workbench and connect to Azure MySQL Database. See my short video for instructions.

Running!

Type your name here for credits.

17. Use the following steps to take a screenshot.

· Open the Snipping Tool. (Click the magnifier icon next to the Windows Start. Search “snipping”.)

· In the Snipping Tool, click “ Mode” then “ Rectangular Snip”. Use Mouse to choose the area where you want to capture.

· In the Snipping Tool, click “ Edit” then “ Copy”. Paste the image below as your answer. Submit this document.

18. Troubleshooting: If you have “Could not start server: argument 2: class 'TypeError': wrong type” error when you try to start you server, refer to step 9 for the fix.

Answer:

<<Paste your screen capture here as your answer.>>

End of Exercise.

1