Matlab和MySQL未找到合适的驱动程序

本文介绍了Matlab和MySQL未找到合适的驱动程序的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在尝试在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/';