I'm interested in using NextAuth with Prisma Adaptor for a MySQL (5.7.36) database, but I encounter the following error:
Error: Specified key was too long; max key length is 1000 bytes
0: sql_migration_connector::apply_migration::migration_step
with step=CreateTable { table_id: TableId(0) }
at migration-engine\connectors\sql-migration-connector\src\apply_migration.rs:21
1: sql_migration_connector::apply_migration::apply_migration
at migration-engine\connectors\sql-migration-connector\src\apply_migration.rs:10
2: migration_core::state::SchemaPush
at migration-engine\core\src\state.rs:381
Basic CRUD operations work fine without NextAuth.
Following the documentation (https://next-auth.js.org/adapters/prisma), I have taken the following steps:
- Created a database named
prisma_mysql - Added the database URL to the .env file. The database URL is as follows (password is empty):
DATABASE_URL="mysql://root:@localhost:3306/prisma_mysql?schema=public"
Installed the required dependencies: npm install next-auth @prisma/client @next-auth/prisma-adapter npm install prisma --save-dev
Now, while attempting to create tables based on the schema below, I am encountering the "key too long" error:
// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema
generator client {
provider = "prisma-client-js"
}
datasource db {
provider = "mysql"
url = env("DATABASE_URL")
}
// Rest of the models and fields go here...
I prefer to use MySQL. Please provide guidance on resolving this issue.