[DataVision-users] Error on connecting to mysql database

[Marty M. <mmc...@fr...>]

Hello,

 

I have just installed Datavision on Ubuntu 12.04 LTS. I can run the program
using the shell script but I cannot connect to the database.

 

I have installed MySQL J driver version mm.mysql-2.0.14. I've edited the
classpath to show the directory that contains the java connector.

 

When I enter the following:

 

Org.gjt.mm.mysql.Driver

Jdbc:mysql://localhost//HOA_Data

HOA_Data

root

password

 

Then click OK the error message is "Java exception communication failure
during handshake. Is there a server running on port 3306?".

I've checked MySql setup and the default port in /etc/my.cfg is 3306.
Netstat -tln tells me that 127.0.0.1 is listening on multiple ports, one is
3306. The server is running.

 

So what am I doing wrong?  It looks like a connection should be made.

 

Thanks,

Marty