drizzle-team / drizzle-team/drizzle-orm
Drizzle Kit fails to connect to mysql database if there is special character in MySql Password.
- 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
Assessment
This issue has not been assessed yet.