MATLAB: Does matlab crash when I try to query from the database(MySql)

Question

After updating MySQL (ver.: 8.0.12) MATLAB crashes every time I try to query from the database (MATLAB has encountered an internal problem and needs to close.). I can successfully connection to the DB, but it crashes when I ty to query. I only encounter the problem when trying to query from the DB, otherwise MATLAB seems to run as normal. I encounter the same problem in 2017b and 2018a.

Answer 1

I think this is the same issue as described in this answer. It might be related to MySQL ODBC 8.x drivers.

There are two workaround.

1. Use other MySQL ODBC Connector versions than 8.x (for example, MySQL ODBC 5.3 )

2. Use JDBC drivers instead of ODBC.

I'm using MySQL JDBC driver 8.0.11 with MATLAB R2018a, it works.