MySQL connection error "Could not create connection to database server"

7 次查看(过去 30 天)
Trying to connect to a MySQL database using the following code:
connS=database(dbname,user,pswd,'Vendor','MySQL','Server','XXX.XXX.X.XXX','PortNumber', 3306);
Receive error:
"Could not create connection to database server."
This error is not noted in https://www.mathworks.com/help/database/ug/database-connection-error-messages.html with regards to how to resolve it or what the potential issue is. Any help would be greatly appreciated

回答(1 个)

Allan Brett
Allan Brett 2019-10-2
Resolved my own issue. This error appears when you are trying to connect to a MySQL database server 8.0 with an incompatible version of Matlab, in this case R2016b. Once I updated Matlab I was able to connect

类别

Help CenterFile Exchange 中查找有关 Database Toolbox 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by