LispWorks User Guide and Reference Manual > 19 Common SQL > 19.2 Initialization > 19.2.8 Connecting to MySQL

NextPrevUpTopContentsIndex

19.2.8.1 Connecting to MySQL using a string

connection-spec can be a string of the form:

username / password / dbname @ hostname : port

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:

me/my-password/my-db@:3307

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.


LispWorks User Guide and Reference Manual - 22 Dec 2009

NextPrevUpTopContentsIndex