我正在尝试在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.amazonawsMyDatabase"
"No suitable driver found for jdbc:mysql://mydatabasehost.amazonawsMyDatabase"
databaseName = 'MyDatabase'; username = 'myusername'; password = 'mypassword'; jdbcDriver = 'com.mysql.jdbc.Driver'; server = ' jdbc:mysql://mydatabasehost.amazonaws'; conn = database(databaseName, username, password, jdbcDriver, server);
我正在使用Matlab R2012(64位). 我已经从 dev.mysql/下载并安装了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 dev.mysql/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';我也应该包含端口号
server = 'jdbc:mysql://mydatabasehost.amazonaws:3306/';更多推荐
Matlab和MySQL未找到合适的驱动程序
发布评论