MySQL Database Installation Document

Install MySQL Database

MySQL Community Server

• Packages for macOS Big Sur (macOS 11) on x86 are compatible with macOS Catalina (macOS 10.15)
• MySQL Community Server Version 8.0.26 must be downloaded!

---

For Windows (x86, 32-bit/64-bit)

MySQL Community MSI Installer 8.0.26

---

For macOS 11 (ARM, 64-bit)

MySQL Community Server 8.0.26

---

For macOS 11 (x86, 64-bit)

MySQL Community Server 8.0.26

Installation

• Install MySQL Using MySQL Community Server Setup
• root user password must be rootpass when setup MySQL Community Server
• Visible in System Preferences when installed MySQL
• Can be Start and Stop MySQL from this screen

Creating the Database

Connect to database with the following information:

User: root
Password: rootpass
URL: jdbc:mysql://localhost:3306

Then, open a new query console from system and execute setup_scripts/setup_sis.sql file.

If you need to run another databases then you need to execute their setup.sql file.

Updating the Database

Commands must be run under mysql directory:

cd mysql

Run the following command to merge database changes:

./sis migrate

Should you need to clean everything and start from starch, issue the following command:

./sis clean migrate

If you are using Windows OS then you need to use these commands with syntax giving below:

sis migrate

sis clean migrate

TEST DB Connection Information

• Connection Type: URL Only
• JDBC URL: jdbc:mysql://yvu4xahse0smimsc.chr7pe7iynqr.eu-west-1.rds.amazonaws.com:3306/njeyua2hj634kcnf

Username	Password
g31ax340gn7k3vy9	p4f2nkus8dhnpyfc

• Click Apply and OK, if visible Succeeded information message when clicked Test Connection button.

MASTER DB Connection Information

• Connection Type: URL Only
• JDBC URL: jdbc:mysql://r6ze0q02l4me77k3.chr7pe7iynqr.eu-west-1.rds.amazonaws.com:3306/lvmp8pcqa129kizx

Username	Password
e2ikxn8dldp8frup	x6fvgr8gj62ba8b9

• Click Apply and OK, if visible Succeeded information message when clicked Test Connection button.

For SUPER Privilege Error!

Error Message;

You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

Run this script in MySQL Console -> SET GLOBAL log_bin_trust_function_creators = 1;