MySQL ODBC for Linux DSN-Less Connection

This tutorial shows how to verify your driver installation and connect to a MySQL^® database using a DSN-less connection string at the command line. (DSN is a data source name.) The tutorial uses the MySQL Connector/J 5.3 driver to connect to a MySQL Version 5.5.16 database on the Linux^® platform.

Step 1. Verify the driver installation.

The ODBC driver is typically preinstalled on your computer. For details about the driver installation or troubleshooting the installation, contact your database administrator or refer to your database documentation on ODBC drivers.

If you need to install an ODBC driver, contact your database administrator or see Installing Connector/ODBC on Unix-Like Systems.

Step 2. Connect using the DSN-less connection string and command line.

1. Connect to the database using the DSN-less connection string with the odbc function. For example, this code assumes that you are connecting to the local database server, database name toystore_doc, user name username, and password pwd.

   dsnless = strcat("Driver={MySQL ODBC 5.3 Ansi Driver}; Server=localhost; ", ...
      "Database=toystore_doc; UID=username; PWD=pwd");
   conn = odbc(dsnless);

2. Close the database connection.

   close(conn)