DrawSplatTM MySQL Setup

Wizard Teacher Admin Open Board

Admin Access

Enter the DrawSplatTM admin password to use the MySQL setup wizard. No password? Click Preview as Viewer for a read-only tour — no real data is loaded.

Request Access

Preview mode — you're looking at the MySQL setup wizard in read-only form. No backend data is loaded. Click Lock Admin to exit and sign in with the real admin password.

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