MySQL Database

Available For Use By:

Faculty

Students

Restrictions:

AWS: Students need to be part of a class that uses this software, consult your professor to ensure access has been provided.

VCL: No restrictions

Available to Be Used On:

AWS Appstream

VCL

Where It May Be Installed

N/A

Description

MySQL Database

Updated August 23, 2024

MySQL Database is used to store data in tables and map them to objects. Some examples of its specific uses are optimizing indexes, data manipulation, and creating a data query.

Below are instructions on how to access MySQL Database on VCL:
1. Go to VCL.
2. Click on the red button that says “Make a Reservation”.
3. If you are not logged in already, click on the “Proceed to Login” button.
4. Sign in with your NCSU account (if a pop-up appears asking to allow notifications, you can just block them).
5. Click on the “New Reservation” button.
6. Click on the dropdown menu and scroll till you see the “PCOM-Lab (AVD)” option.
7. Select that option and click on the “Connect”.
8. A pop-up box will appear showing instructions on how to connect to PCOM-Lab in AVD. Click on the computer icon that appears with the name “PCOM-Lab” below it.
9. If you are not signed into AVD, then you will be asked to sign in. Please do so with your NCSU account.
10. Once you are in AVD, you will see at least on computer icon. Click on the one with the name “PCOM-Lab”.
11. You may have to wait a few minutes for PCOM-Lab to set up. Afterwards, you will be asked to sign in again. Please do so with your NCSU account.
12. Once you are signed in, you should now be connected to the machine. You now have access the MySQL Database

This link gives instructions on how to access MySQL Database on AWS.
This link gives instructions on how to do basic and common tasks on MySQL Database.
This link gives more detailed documentation on MySQL Database.