drizzle-team / drizzle-team/drizzle-orm

Drizzle Kit fails to connect to mysql database if there is special character in MySql Password.

Open
#3,337 2 comments 0 reactions 0 assignees View on GitHub
bug drizzle/kit
Dominant language
TypeScript
Stars
35.8k
Forks
1.6k
Avg merge
2d 7h
Merged PRs (30d)
4

Description

Drizzle kit mains functions - migrate, introspect, studio giving error if there is Special Characters in Password of MySQL.

`import { defineConfig } from 'drizzle-kit';

export default defineConfig({
schema: './src/schema.ts',
out: './drizzle',
dialect: 'mysql',
dbCredentials: {
dbCredentials: {
url: 'mysql://sample_user:B%6UI6_vy]B*@sample_host:3306/sample_user'
},
},
});
`

Even if I use EncodeUrl still the error persists.

`
Error: Access denied for user 'mysql://sample_user:B%6UI6_vy]B*@sample_host:3306/sample_user' (using password: YES)
at createConnection (/Users/snune/Desktop/api-services-current/node_modules/.pnpm/drizzle-kit@0.23.0/node_modules/drizzle-kit/bin.cjs:120692:35)
at connectToMySQL (/Users/snune/Desktop/api-services-current/node_modules/.pnpm/drizzle-kit@0.23.0/node_modules/drizzle-kit/bin.cjs:121554:48)
at async _Command. (/Users/snune/Desktop/api-services-current/node_modules/.pnpm/drizzle-kit@0.23.0/node_modules/drizzle-kit/bin.cjs:131540:27) {
code: 'ER_ACCESS_DENIED_ERROR',
errno: 1045,
sqlState: '28000'
}`

Versions

drizzle-kit: 0.23.0,
drizzle-orm: 0.32.0,
node: 20.15.1

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.