BetterAuth.MySQL reference

MySQL

Source: packages/better-auth/src/MySQL.ts Kind: Layer · Provides: BetterAuth.Database · Peer dependencies: mysql2

Generic TCP MySQL database layer for Better Auth, from a connection string.

Works with PlanetScale MySQL, Cloudflare Hyperdrive MySQL origins, AWS RDS MySQL, or any literal URL. One mysql2 pool per execution, closed when the event settles.

MySQL: Connecting to PlanetScale MySQL

PlanetScale requires TLS — pass it in the URL’s ssl query parameter (mysql2 parses it as JSON).

import { BetterAuth } from "@alchemy.run/better-auth";
import { MySQL } from "@alchemy.run/better-auth/MySQL";

const password = yield* Planetscale.MySQLPassword("auth-db", {
  database,
  role: "admin",
});
const url =
  `mysql://${password.username}:...@${password.host}/${database.name}` +
  `?ssl=${encodeURIComponent('{"rejectUnauthorized":true}')}`;

Effect.gen(function* () {
  const auth = yield* BetterAuth({ emailAndPassword: { enabled: true } });
  return { fetch: ... };
}).pipe(Effect.provide(MySQL(url)))