Can't connect to db if the db user's password has '@' symbol in it.

Shopify Apps

Topic summary

A database connection issue occurs when the database user’s password contains an [email removed] symbol. The problem appears to be related to URL parsing in the connection string format mysql://root:P@ssw0rd@localhost:3306/testdb.

Technical Context:

  • The [email removed] symbol in passwords conflicts with the [email removed] delimiter used in MySQL connection URLs to separate credentials from the host
  • Standard connection string format: mysql://username:password@host:port/database

Current Status:

  • Issue reported but no solution or workaround provided yet
  • Likely requires URL encoding the password (replacing [email removed] with ‘%40’) or using alternative connection configuration methods
  • Discussion remains open with the core problem identified
Summarized with AI on November 14. AI used: claude-sonnet-4-5-20250929.
1

If my database user’s password has [email removed] symbol in it then the connection will fail.

datasource db {
  provider = "mysql"
  url      = "mysql://root:P@ssw0rd@localhost:3306/testApp"
}