This is an old revision of the document!
MySQL
MySQL is an open-source relational database management system. Its name is a combination of “My”, the name of co-founder Michael Widenius's daughter, and “SQL”, the abbreviation for Structured Query Language. Brimble.com uses MySQL to store the tables for most all things running on the server.
Version
I used the official docker from Bungy's repository.
Docker Setup
Network Type: Custom: brimble
Fixed IP address (optional): blank
Console shell command: Shell
Privileged: off
Host Port 1: 3306
Host Path 1: /mnt/disks/samsung_ssd/appdata/mysql
Key 1 (MYSQL_ROOT_PASSWORD):
Key 2 (MYSQL_DATABASE): nextcloud (i used this to create the nexcloud structure… added more later)
Key 3 (MYSQL_USER):
Key 4 (MYSQL_PASSWORD):
App Settings
User standard SQL commands to import databases from back up, allow privileges, etc.
See Install MySql section of installing ubuntu pages for most commands. write access is not needed as that feature was removed by changing the way the NCAA pool temp stores the data.