Matlab和MySQL未找到合适的驱动程序 [英] Matlab and MySQL no suitable driver found

问题描述

我正在尝试在Matlab中使用以下代码连接到MySQL数据库，但是却收到错误消息

I am trying to connect to MySQL database with the following code in Matlab, but I am getting the error message

"找不到适合的驱动程序 jdbc:mysql://mydatabasehost.amazonaws.comMyDatabase"

"No suitable driver found for jdbc:mysql://mydatabasehost.amazonaws.comMyDatabase"

databaseName = 'MyDatabase';
username = 'myusername';
password = 'mypassword';
jdbcDriver = 'com.mysql.jdbc.Driver';
server = ' jdbc:mysql://mydatabasehost.amazonaws.com';

conn = database(databaseName, username, password, jdbcDriver, server);

我正在使用Matlab R2012(64位). 我已经从 http://dev.mysql.com/下载并安装了Windows的JDBC连接器.下载/连接器/j/ 我已将其添加到Matlab的classpath.txt中(或者使用javaaddpath(jdbc驱动程序的位置).我是否缺少步骤了?

I am using Matlab R2012 (64bit). I have already downloaded and installed the JDBC connector for Windows from http://dev.mysql.com/downloads/connector/j/ I have added it to classpath.txt of Matlab (alternatively use javaaddpath(location of the jdbc driver). Am I missing a step?

推荐答案

好的，请关闭此问题.

问题是开头的间距

server = ' jdbc:mysql://mydatabasehost.amazonaws.com';

我也应该包含端口号

server = 'jdbc:mysql://mydatabasehost.amazonaws.com:3306/';

这篇关于Matlab和MySQL未找到合适的驱动程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！