Invalid connection when connecting to MySQL.

11 次查看（过去 30 天）
Chen Zeyu
Chen Zeyu 2022-5-12
回答： Shanmuganathan 2022-11-22
I wrote my code as official guide of database toolbox as follows:
myconn=database('xxx','yy','zzz','com.mysql.jdbc.Driver','jdbc:mysql://121.41.144.24:11106/xxx')
sqlquery = "SELECT * FROM dw_IndexQuote";
data = select(myconn,sqlquery);
However, it report an error that Invalid connection.
the attribute of the connection is:
AutoCommit: ''
ReadOnly: ''
LoginTimeout: 0
MaxDatabaseConnections: -1
I don't know why. The information of connection is correct and I can use python to connect. I think there may be a mistake in configuration but I cannot figure it out.

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

回答（1 个）

Shanmuganathan
Shanmuganathan 2022-11-22
Hi Chen,
I understand that you are facing an issue when trying to connect to MySQL database.
Please follow the below documentation to setup the data source and connect to MySQL database:
MySQL JDBC for Windows - MATLAB & Simulink - MathWorks India
Regards,
Shanmuganathan

类别

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

标签

产品


版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by