I want to use "/" in the name of DB. What should I do?

[oshiro3]

Issue description

I want to use "/" in the DSN for the database name, such as xxx/yyy, but I get the error invalid DSN: did you forget to escape a param value? .
Using url.Escape () will evaluate the database name as xxx%2Fyyy.
How should I solve it?

I use go-sql-driver through golang-migrate/migrate library.

Example code

sql.Open("mysql", "user@tcp(host:port)/xxxx/yyy")

Error log

invalid DSN: did you forget to escape a param value?

Configuration

Driver version (or git SHA):

v1.5.0

Go version: run go version in your console

go1.15.3

Server version: E.g. MySQL 5.6, MariaDB 10.0.20

MySQL 5.7

Server OS: E.g. Debian 8.1 (Jessie), Windows 10

MacOS Catalina

xxx/yyy for the database name is not a valid DSN value so it won't work.
This is the DSN format

[username[:password]@][protocol[(address)]]/dbname[?param1=value1&...&paramN=valueN]

As for the database name you have to remove the extra slash - /xxxyyy

[zihengCat]

@oshiro3
Sorry, you couldn't use a slash / in your db name because of DSN format parsing mechanism.

And a database name which contains slash / is really bad in my personal thought. :(

[zihengCat]

This issue could be closed safely.

[oshiro3]

@zihengCat @evergreen-trading-systems
Thank you for the answer!
I just want to know, is invalid based on the DSN specification, or is it invalid as an implementation specification in go-sql-driver?
If there is an official DSN specification, please let us know.
I looked for it but couldn't find it...

[zihengCat]

@oshiro3
It's go-sql-driver implementation specified. The driver defined the rule that a valid DSN must follows:

[username[:password]@][protocol[(address)]]/dbname[?param1=value1&...&paramN=valueN]

There is no official DSN specification, Go team leave driver implementers define their own DSN format, which is much suitable and flexible for driver implementing.

[dolmen]

To see what ParseDSN expects, the best is to fill a Config (use NewConfig) with your settings and call its FormatDSN method to see what it outputs.

Here is a template: https://go.dev/play/p/8E3WFHsTTJc

[dolmen]

This has been fixed by #1432.