We are going to assume that you have limited to no knowledge of MySQL usage for the sake of clarity for first time users.

There are many options to choose from for setting up your database using SQL commands. We are not going to suggest any one but at the very least your installation should have been installed with some sort of interface. As of the writing of this document, we are using the default management application for MySQL, called MySQL Workbench. For MariaDB, it is called HeidiSQL.

The user you are using to log into the database with your selected interface should be an administrator account that has the ability to grant privileges. These are the commands to run as queries from a query command interface. You may prefer to do the same from a GUI.

In the following examples we are going to assume that you are going to create a database named ‘Scolo’ for the Scolo application to use. The service account we are going to create has a login name of ‘service_Scolo’ and ‘password_Scolo’ for the account password. Substitute the values used in the command with whatever you wish to use at your property.

This command will create an empty database named ‘Scolo’.

CREATE DATABASE `Scolo`;

These commands create a user account named ‘service_Scolo’ with a password of ‘password_Scolo’. The ‘@’%’ part of the create user command allows that service account to connect from any client PC. For better security ou may wish to search online for documentation to modify the 'create user' command syntax to narrow down from what computers are allowed to connect to this database.

CREATE USER 'service_Scolo'@'%' IDENTIFIED BY 'password_Scolo';

GRANT CREATE, DROP, ALTER, DELETE, INSERT, SELECT, UPDATE, CREATE ROUTINE, EXECUTE, CREATE TEMPORARY TABLES, EVENT ON Scolo.* TO 'service_Scolo'@'%';

All map images are stored in the database. In order to save larger data to the stock MySQL configuration, you must add the following line to the MySQL configuration file. In the example we are allowing a 16 MB file to be stored in a record on the database. Use a slightly larger value of what you think will be the largest image file size you will use.

# this will allow 16 MB files to be saved.
max_allowed_packet=16777216