squirrel sql mysql_无法使用SQuirreL连接到MySQL数据库

我无法使用客户端Squirrel SQL连接到

MySQL.我之前设法连接到Oracle和Derby,但这一次,我不知道我做错了什么.

我在Mac上安装了MySQL,遵循以下步骤：

>要安装MySQL：

ruby -e "$(curl -fsSL /mxcl/homebrew/go)"

brew install git

brew update

brew install mysql

>确保安装：

mysql.server start

mysql_secure_installation

mysql.server stop

>要创建新数据库：

mysql.server start

mysql -uroot -pmypassord

create database mydb;

show databases;

>要知道数据库的存储位置：

mysql.server start

mysql -uroot -pmypassword

SELECT @@datadir, @@innodb_data_home_dir

>创建表格

use mydb;

create table tblemployee (

employeeID int not null,

firstname varchar(50),

lastname varchar(50),

titleID int,

salary float,

primary key (employeeID)

);

我按照这些步骤后：

> MySQL安装在/usr/local/Cellar/mysql/5.6.17下

>数据库存储在/usr/local/var / mysql / mydb下

>表tblemployee已成功创建.

在SQuirreL中,我接着安装了MySQL的驱动程序(mysql-connector-java-5.1.30-bin)并创建了一个URL为“jdbc：mysql：/usr/local/var / mysql / mydb”的别名,用户名作为“root”,密码作为“mypassword”.

但是当我尝试连接时,我收到以下错误消息：

Unexpected Error occurred attempting to open an SQL connection.

当我点击Stack Trace时,这就是我得到的：

java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: Unable to create connection. Check your URL.

at java.util.concurrent.FutureTask.report(FutureTask.java:122)

at java.util.concurrent.FutureTask.get(FutureTask.java:202)

at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(Unknown Source)

at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(Unknown Source)

at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(Unknown Source)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

at java.util.concurrent.FutureTask.run(FutureTask.java:262)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at java.lang.Thread.run(Thread.java:744)

Caused by: java.lang.RuntimeException: java.sql.SQLException: Unable to create connection. Check your URL.

at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(Unknown Source)

at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(Unknown Source)

at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(Unknown Source)

... 5 more

Caused by: java.sql.SQLException: Unable to create connection. Check your URL.

at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(Unknown Source)

... 8 more

我究竟做错了什么？