INSTALLATION AND SET UP
-
Download the appropriate Lab Sort version and license here.
-
Extract the downloaded "Lab Sort - ... .zip" file and open the folder to view the files.
-
(VARIABLE) If you already have a MySQL 8.0 server/database and can access it with permissions to CREATE, ALTER, and ACCESS databases, permissions to CREATE, ALTER, ACCESS, and DROP tables, and permissions to INSERT, UPDATE, SELECT, and DELETE in those tables, skip to step 9. Talk to your IT manager to verify these permissions (MySQL will have limited functionality without them).
-
Run the MySQL installer provided in the unzipped folder, or download the latest version here.
-
Choose the custom installation option, and only select the latest version of MySQL 8.0 Server and the latest version of MySQL workbench (under Applications).
-
Install and configure the two packages from step 5. Using the default configuration is fine.
-
The database server will need a password for its root account. If you are installing these packages on a local machine, the Host Name will be “localhost”, the User Name will be “root” and the Password will be whatever is set here. (There is no need to set up additional users at this time).
-
Execute the installation of all of the packages and run MySQL workbench. From here, you will be able to add users, create and drop databases, and check tables. PLEASE DO NOT ALTER DATABASES OR TABLES THAT ARE IN USE BY LAB SORT - THIS WILL RESULT IN DATA LOSS AND ERRORS.
-
Run the Lab Sort Setup and install Lab Sort.
-
Run Lab Sort. To connect to the database on login, the Host Name will be an IP address or “localhost” depending on where the server is located. The User Name will be any user associated with the selected server (“root” is the default), and the Password will be whatever the User Name’s associated password is. The Database can be given almost any one-word name, with some exceptions. To create a new database, just type in a name and click confirm.
-
You have successfully installed Lab Sort!