MySQL ODBC Connection using SSL

2 次查看（过去 30 天）
Afzal Ali
Afzal Ali 2018-2-3
回答： 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&');

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

回答（1 个）

HimeshNayak
HimeshNayak 2023-3-16
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

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by