invalid userinfo when use password include special characters

[calvin2021y]

invalid userinfo when use password include special characters

[a8m]

Hey @calvin2021y 👋🏻

Yes, please check out this comment #1034 (comment):

As the command accepts a URL, the standard way for dealing with odd characters is using URL encoding, see IETF RFC 1738, (see section 2.2) which defines URLs formally. I don't think Atlas should encode the URL for the user as this is a one-time operation (e.g doesn't change unless the password itself changes).

[calvin2021y]

even so, add a arguments to accept raw password will be much easy for users.

[a8m]

Agree. That’s why we added urlescape to Atlas configuration.

[calvin2021y]

Can i use this from bash command without change code ?

[a8m]

Create an atlas.hcl file and use the urlescape function. The URL (of an actual database) should not be stored in the file but injected as a variable or read from some secrets store (Atlas supports this too). For example:

variable "url" {
  type     = string
  default = "<local url"> // Can also be defined as: getenv("DATABASE_URL")
}

env "mysql" {
  url  = urlescape(var.url)
  src = "file://test.hcl"
  # In case you use and want to define a dev-database.
  dev = "docker://mysql/8/dev"
}

atlas schema apply \
  --env mysql \
  --var "url=mysql://test:+ysT*Au-83b57X9^t2@mysql:3306/test"

[calvin2021y]

thanks for the tips, after some research I find this tools work suit me need.

trurl --url mysql://MYSQL_HOST --set port=$MYSQL_PORT --set user=$MYSQL_USER --set password=$MYSQL_PWD

https://github.com/curl/trurl