DrawSplatTM MySQL Setup

Wizard Teacher Admin Open Board

Admin Access Required

Enter the DrawSplatTM admin password to use the MySQL setup wizard.

Request Access

MySQL Backend Setup Wizard

Use this page to prepare a self-hosted DrawSplatTM backend that stores rooms, boards, templates, media references, turn-ins, and retention metadata in MySQL. Google Apps Script can stay enabled as a separate storage option.

1

Install Backend

Deploy the starter backend in server/mysql-backend on a server that can reach MySQL.

2

Create Database

Run schema.sql, then put the database credentials in the server-side .env file.

3

Connect DrawSplatTM

Save the public API endpoint here. Do not put the MySQL password in this browser page.

Public API Endpoint

This is the URL DrawSplatTM can call. It should point to the backend API, not directly to MySQL.

Server-Side Database Settings

Use these fields to generate a server-only .env template. The password is not saved in the browser.

Generated .env Template

Put this on the backend server as server/mysql-backend/.env. Keep it out of Git and away from students.

Backend Endpoint Contract

  1. GET /health verifies the backend is alive.
  2. GET /rooms/:roomId/board loads the current room board.
  3. PUT /rooms/:roomId/board saves board JSON.
  4. POST /templates saves reusable templates.
  5. POST /turnins stores student submissions.
  6. DELETE /sessions/:sessionId clears temporary sessions.
Read Backend Guide View Schema