authjs-adapter-mysql2 v0.0.3

How to use

Install:

npm i authjs-adapter-mysql2

use schema.sql to create the tables.

import Mysql2Adapter from "authjs-adapter-mysql2";
import * as mysql from 'mysql2/promise';``

function getConnection() {
  return mysql.createConnection({
    host: '127.0.0.1',
    user: 'root',
    database: 'fancydb'
  });
}
export default NextAuth({
    adapter: Mysql2Adapter(getConnection),
    providers: []
});

PlanetScale

• https://planetscale.com/docs/learn/operating-without-foreign-key-constraints
• https://planetscale.com/blog/why-we-chose-nanoids-for-planetscales-api