MySQL ODBC Connection using SSL

Question

Afzal Ali 2018-2-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/380606-mysql-odbc-connection-using-ssl

回答： HimeshNayak 2023-3-16

What would be the ODBC equivalent of the following:

hconn = database('{schema name}','{username},'{password}',...
                    'com.mysql.jdbc.Driver',...
                    'jdbc:mysql://testazureserver.mysql.database.azure.com:3306/{schema name}?...
                     useSSL=true&requireSSL=false&autoReconnect=true&');

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

HimeshNayak 2023-3-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/380606-mysql-odbc-connection-using-ssl#answer_1194035

在 MATLAB Online 中打开

Hi Afzal

As per my understanding you want to convert our JDBC code to ODBC. Here is the code you are looking for:

conn = odbc("Driver={MySQL ODBC 8.0 ANSI Driver};" + ...
    "Server=testazureserver.mysql.database.azure.com;" + ...
    "Port=3306;" + ...
    "Database={schema name};" + ...
    "Uid={username};" + ...
    "Pwd={password};" + ...
    "sslmode=REQUIRED;");

You would also have to install the “MySQL ODBC driver” on your system and replace {schema name}, {username}, and {password} with your own values. You may also need to adjust the “Driver name” and “SSL parameters” based on your configuration.

For more information about “odbc”, refer to the following link:

https://in.mathworks.com/help/database/ug/odbc.html

Regards

HimeshNayak