如何修复mysql指定键的NextAuth与Prisma太长-错误

Question

我愿意使用与Mysql(5.7.36)数据库的Prisma适配器NextAuth，但我得到以下错误。

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-engineconnectorssql-migration-connectorsrcapply_migration.rs:21
1: sql_migration_connector::apply_migration::apply_migration
at migration-engineconnectorssql-migration-connectorsrcapply_migration.rs:10
2: migration_core::state::SchemaPush
at migration-enginecoresrcstate.rs:381

没有nextauth，我可以做基本的CRUD操作，没有任何问题。

根据文档(https://next-auth.js.org/adapters/prisma)，我遵循了所有的步骤，如。

1. 创建名称为prisma_mysql的数据库
2. 在。env文件中增加了数据库urs。数据库url为(密码为空)

DATABASE_URL="mysql://root:@localhost:3306/prisma_mysql?schema=public"

3. 安装了所需的依赖项NPM install next-auth @prisma/client @next-auth/prism -adapterNPM install prism——save-dev

4. 现在这里是shcema，我试图创建表，但得到键太长错误。

// 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")
}
model Account {
id                 String  @id @default(cuid())
userId             String
type               String
provider           String
providerAccountId  String
refresh_token      String?  @db.Text
access_token       String?  @db.Text
expires_at         Int?
token_type         String?
scope              String?
id_token           String?  @db.Text
session_state      String?
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
@@unique([provider, providerAccountId])
}
model Session {
id           String   @id @default(cuid())
sessionToken String   @unique
userId       String
expires      DateTime
user         User     @relation(fields: [userId], references: [id], onDelete: Cascade)
}
model User {
id            String    @id @default(cuid())
name          String?
email         String?   @unique
emailVerified DateTime?
image         String?
accounts      Account[]
sessions      Session[]
}
model VerificationToken {
identifier String
token      String   @unique
expires    DateTime
@@unique([identifier, token])
}

我想使用mysql，请让我知道修复

Answer 1

访问phpmyadmin>点击SQL粘贴

SET GLOBAL default_storage_engine = 'InnoDB';

为我工作。