MATLAB R2018a crashes when using MySQL ODBC 8.x drivers

When connecting to any MySQL Database using ODBC Driver 8.x,  MATLAB R2018a crashes.

>> conn = database('MySQL_DS','dta','dtarocks')
>> curs = exec(conn,'SELECT * FROM productTable');
>> close(conn)

MATLAB crashes with following stack trace:

Stack Trace (from fault):
[  0] 0x00007ff8ac5d1fcc C:\Program Files\MySQL\Connector ODBC 8.0\myodbc8a.dll+00401356 SQLDescribeParam+00388880
[  1] 0x00007ff8b56f2180 C:\Program Files\MATLAB\R2018a\bin\win64\LIBEAY32.dll+00008576 CRYPTO_lock+00000160
[  2] 0x00007ff8d583e4e5 C:\Program Files\MATLAB\R2018a\bin\win64\SSLEAY32.dll+00189669 SSL_COMP_set0_compression_methods+00000517
[  3] 0x00007ff8d583e2c2 C:\Program Files\MATLAB\R2018a\bin\win64\SSLEAY32.dll+00189122 SSL_COMP_get_compression_methods+00000018
[  4] 0x00007ff8d584568c C:\Program Files\MATLAB\R2018a\bin\win64\SSLEAY32.dll+00218764 SSL_library_init+00000524
[  5] 0x00007ff8ac5d2569 C:\Program Files\MySQL\Connector ODBC 8.0\myodbc8a.dll+00402793 SQLDescribeParam+00390317
[  6] 0x00007ff8ac5b907f C:\Program Files\MySQL\Connector ODBC 8.0\myodbc8a.dll+00299135 SQLDescribeParam+00286659
[  7] 0x00007ff8ac5ae775 C:\Program Files\MySQL\Connector ODBC 8.0\myodbc8a.dll+00255861 SQLDescribeParam+00243385
[  8] 0x00007ff8ac57db95 C:\Program Files\MySQL\Connector ODBC 8.0\myodbc8a.dll+00056213 SQLDescribeParam+00043737
[  9] 0x00007ff8ac57d230 C:\Program Files\MySQL\Connector ODBC 8.0\myodbc8a.dll+00053808 SQLDescribeParam+00041332
[ 10] 0x00007ff8ac59e349 C:\Program Files\MySQL\Connector ODBC 8.0\myodbc8a.dll+00189257 SQLDescribeParam+00176781
[ 11] 0x00007ff8b427e314                     C:\WINDOWS\SYSTEM32\ODBC32.dll+00320276 SQLTransact+00003668
[ 12] 0x00007ff8b4264a53                     C:\WINDOWS\SYSTEM32\ODBC32.dll+00215635 SQLConnectW+00003523
[ 13] 0x00007ff8b426467e                     C:\WINDOWS\SYSTEM32\ODBC32.dll+00214654 SQLConnectW+00002542
[ 14] 0x00007ff8b4296013                     C:\WINDOWS\SYSTEM32\ODBC32.dll+00417811 SQLConnect+00000499

 

Answer 1

[MathWorks Support Team]

This is a known incompatibility issue with the MySQL ODBC 8.x drivers.

Please use below workarounds to resolve the issue:

1. MySQL ODBC Connector versions other than 8.0.x (e.g. ODBC 5.3) can be used to resolve the issue 

2. JDBC drivers can be used to resolve the issue.