Today, the only way to setup the MySQL database is via the create-db.js script. In a following diff, I'm working on making Node automatically setup the database if it is not set up.
In preparation for that, I'm moving the code in create-db.js to use the per-query { multipleStatements: true } option to dbQuery, instead of globally declaring setScriptContext({ allowMultiStatementSQLQueries: true, }).
This has the additional benefit of improving security for queries where we don't actually need multiple statements.