MYSQL is not working with Prisma STUDIO #1422
Description
Bug description
I am trying to run prisma studio using the following command
pnpm prisma studio --config ./prisma.config.ts
The browser opens but I get "introspect"operation failed message.
prisma.config.ts
// Auto generated: Prisma Config file
import { defineConfig,env } from 'prisma/config'
import 'dotenv/config'
export default defineConfig({
schema: 'prisma',
migrations: {
path: 'prisma/migrations',
},
datasource: {
url: env("DATABASE_URL_MYSQL")
},
})
Debug Log
pnpm prisma studio --config ./prisma.config.ts
prisma:cli:bin Failed to initialize the command state: Error: ENOENT: no such file or directory, open '/Users/piyush/Library/Preferences/prisma-nodejs/commands.json' +422ms
prisma:config:defineConfig [default]: '{\n "loadedFromFile": null\n}' +302ms
prisma:config:defineConfig [config.schema]: 'prisma' +1ms
prisma:config:defineConfig [config.datasource]: '{\n "url": "mysql://root:password@localhost:3306/local"\n}' +0ms
prisma:config:defineConfig [config.migrations]: '{\n "path": "prisma/migrations"\n}' +0ms
prisma:config:loadConfigFromFile Config file loaded in 29.36ms +0ms
prisma:config:PrismaConfig Parsing PrismaConfigInternal: '{\n' +
' "loadedFromFile": null,\n' +
' "schema": "prisma",\n' +
' "datasource": {\n' +
' "url": "mysql://root:password@localhost:3306/local"\n' +
' },\n' +
' "migrations": {\n' +
' "path": "prisma/migrations"\n' +
' }\n' +
'}' +0ms
prisma:config:PrismaConfig Short-circuit: input is already a PrismaConfigInternal object +0ms
Loaded Prisma config from ./prisma.config.ts.
Prisma Studio is running at: http://localhost:51212
prisma:getSchema Reading schema from multiple files./prisma +62ms
prisma:getSchema Reading schema from multiple files ./prisma +0ms
prisma:getConfig Using getConfig Wasm +1ms
prisma:getConfig config data retrieved without errors in getConfig Wasm +5ms
prisma:cli:checkpoint runCheckpointClientCheck(): Execution time for getting info: 37.45370799999995 ms +0ms
prisma:cli:checkpoint runCheckpointClientCheck(): Execution time for "await checkpoint.check(data)": 4.4898339999999735 ms +5ms
prisma:cli:bin Execution time for executing "await cli.parse(commandArray)": 42.51720900000004 ms +0ms
How to reproduce
Expected behavior
No response
Prisma information
Environment & setup
- OS:
- Browser:
- Database:
Prisma logs
No response