MySQL

Libraries

The MySQL back-end needs access to the MySQL C client library (libmysqlclient.so). The location of this library is specified via *mysql-so-load-path*, which defaults to /usr/lib/libmysqlclient.so. Additional flags to ld needed for linking are specified via *mysql-so-libraries*, which defaults to ("-lc").

Initialization

Use

(asdf:operate 'asdf:load-op 'clsql-mysql)
	

to load the MySQL back-end. The database type for the MySQL back-end is :mysql.

Connection Specification

Syntax of connection-spec

(host db user password)

Description of connection-spec

host

String representing the hostname or IP address the MySQL server resides on, or nil to indicate the localhost.

db

String representing the name of the database on the server to connect to.

user

String representing the user name to use for authentication, or nil to use the current Unix user ID.

password

String representing the unencrypted password to use for authentication, or nil if the authentication record has an empty password field.