Why do I receive an error message in the output of the DATABASE function when I try to connect to a mySQL database using ODBC with the Database Toolbox?

Why do I receive an error message in the output of the DATABASE function when I try to connect to a mySQL database using ODBC with the Database Toolbox?

I am using the Database toolbox to connect to a mySQL database on a Microsoft Windows computer. I am using the ODBC driver to connect to the database. I use the following code at the MATLAB command prompt:

conn = database('unixIndexDB','','');

conn.message

However, I get the following error message in the "message" field of the output structure "conn":

 ans =

 [MySQL][ODBC 3.51 Driver]You have an error in your SQL syntax.  Check the manual that 

 corresponds to your MySQL server version for the right syntax to use near 

 'Connecting to mySQL' at line 1

Answer 1

[MathWorks Support Team]

This error is thrown if the ODBC setup for the mySQL database is not correct for the data source. The configuration dialog box for mySQL data source settings in ODBC has a field for "SQL command on connect". This field should be set to an SQL command that is executed when someone tries to connect to the data source. This command has the following format:

 use database_name

where database_name has to be the name of your data source that is provided in the configuration dialog box. If the USE command does not use the correct data source name, mySQL throws the error message above that is reflected in the "message" field of the output of the DATABASE command in MATLAB.

[JohnGalt]

if you don't have the database toolbox you can use: https://www.mathworks.com/matlabcentral/fileexchange/57195-niallhurley-mysql_matlab