Error: Either `connectionString` or `host, port, etc.` params be provided in config file
Hey,
So i'm trying to setup Drizzle with PlanetScale, and want to use the drizzle kit push command, but i run into this error:
Config
I'm using a connectionString that is formatted like this in my .env:
Everything i can google my way to, do it the same way, and i really can't seem to figure out what i'm doing wrong here?
Anyone that can point me in the right direction
So i'm trying to setup Drizzle with PlanetScale, and want to use the drizzle kit push command, but i run into this error:
throw Error(
^
Error: Either `connectionString` or `host, port, etc.` params be provided in config file
at connectToMySQL (/Users/oscar/Projects/popfeed/node_modules/drizzle-kit/index.js:45561:15)
at Command2.<anonymous> (/Users/oscar/Projects/popfeed/node_modules/drizzle-kit/index.js:51266:28)
at Command2.listener [as _actionHandler] (/Users/oscar/Projects/popfeed/node_modules/drizzle-kit/index.js:832:21)
at /Users/oscar/Projects/popfeed/node_modules/drizzle-kit/index.js:1251:69
at Command2._chainOrCall (/Users/oscar/Projects/popfeed/node_modules/drizzle-kit/index.js:1183:16)
at Command2._parseCommand (/Users/oscar/Projects/popfeed/node_modules/drizzle-kit/index.js:1251:31)
at /Users/oscar/Projects/popfeed/node_modules/drizzle-kit/index.js:1120:31
at Command2._chainOrCall (/Users/oscar/Projects/popfeed/node_modules/drizzle-kit/index.js:1183:16)
at Command2._dispatchSubcommand (/Users/oscar/Projects/popfeed/node_modules/drizzle-kit/index.js:1116:27)
at Command2._parseCommand (/Users/oscar/Projects/popfeed/node_modules/drizzle-kit/index.js:1222:23) throw Error(
^
Error: Either `connectionString` or `host, port, etc.` params be provided in config file
at connectToMySQL (/Users/oscar/Projects/popfeed/node_modules/drizzle-kit/index.js:45561:15)
at Command2.<anonymous> (/Users/oscar/Projects/popfeed/node_modules/drizzle-kit/index.js:51266:28)
at Command2.listener [as _actionHandler] (/Users/oscar/Projects/popfeed/node_modules/drizzle-kit/index.js:832:21)
at /Users/oscar/Projects/popfeed/node_modules/drizzle-kit/index.js:1251:69
at Command2._chainOrCall (/Users/oscar/Projects/popfeed/node_modules/drizzle-kit/index.js:1183:16)
at Command2._parseCommand (/Users/oscar/Projects/popfeed/node_modules/drizzle-kit/index.js:1251:31)
at /Users/oscar/Projects/popfeed/node_modules/drizzle-kit/index.js:1120:31
at Command2._chainOrCall (/Users/oscar/Projects/popfeed/node_modules/drizzle-kit/index.js:1183:16)
at Command2._dispatchSubcommand (/Users/oscar/Projects/popfeed/node_modules/drizzle-kit/index.js:1116:27)
at Command2._parseCommand (/Users/oscar/Projects/popfeed/node_modules/drizzle-kit/index.js:1222:23)Config
import type { Config } from 'drizzle-kit';
export default {
schema: './src/lib/db/schema.ts',
out: './src/lib/db/migrations',
connectionString: process.env['DATABASE_URL']
} satisfies Config;import type { Config } from 'drizzle-kit';
export default {
schema: './src/lib/db/schema.ts',
out: './src/lib/db/migrations',
connectionString: process.env['DATABASE_URL']
} satisfies Config;I'm using a connectionString that is formatted like this in my .env:
DATABASE_URL='mysql://USERNAME:[email protected]/popfeed?sslaccept=strict'DATABASE_URL='mysql://USERNAME:[email protected]/popfeed?sslaccept=strict'Everything i can google my way to, do it the same way, and i really can't seem to figure out what i'm doing wrong here?
Anyone that can point me in the right direction
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879Members
Resources
Was this page helpful?
