Mysql ODBC Connection

An ODBC connection will give many programs (E.G. spss) access to a MySQL database.

• Download and install the MySQL Connector/ODBC from MySQL. The "msi" is the easiest.
• Start, Control Panel, Administrative Tools, Data Sources (ODBC)
• Choose System DSN, Add, MySQL ODBC Driver
• Name the DSN, host localhost, enter username and password, select the appropriate database
• Click OK