19.2.8.1 Connecting to MySQL using a string

connection-spec can be a string of the form:

where port is a decimal number specifying the port number to use. port can be omitted along with the preceding ' : '.

hostname can be omitted. If port is omitted too, the ' @ ' can be omitted as well. If port is supplied and hostname is not supplied, then both the ' @ ' and the ' : ' are required, for example:

hostname may also specify a unix socket name, which must start with the character ' / '.

dbname may be omitted along with the preceding ' / '.

password may be omitted. If dbname is also omitted, the preceding ' / ' can be omitted too.

username may be omitted.