info

Note: Local mode runs on SQLite by default and needs no MySQL server or Docker. This guide only applies when you want to develop or test against the hosted-mode MySQL database (set a mysql:// DATABASE_URL).

codesql 
CREATE DATABASE gengine_studio CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_as_cs;
CREATE USER 'gengine_studio_user'@'localhost' IDENTIFIED BY '<generated-secret>';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, INDEX, DROP, REFERENCES
  ON gengine_studio.* TO 'gengine_studio_user'@'localhost';

Keep strict SQL mode and UTC. Then run pnpm db:migrate, pnpm db:seed, and pnpm doctor. Setup does not overwrite an existing MySQL configuration.