Page 1 of 1

Max OSX unable to connect to MySql DB

Posted: Fri Jan 14, 2011 6:54 pm
by jwc
I'd like to use oXygen as my client for MySql (I've heard it's very good for this and I'm in it all day anyway) but I can't get it to connect.

I'm running OSX 10.6 (up to date) and oXygen 11.2

I installed the most recent ODBC drivers from MySql's site for 64-bit OSX

When I try to connect I get this error:

java.sql.SQLException: Communication failure during handshake. Is there a server running on jwc.dev:3306?
Communication failure during handshake. Is there a server running on jwc.dev:3306?

I can connect to the same machine with Sequel Pro or on the command line - I verified it's on the right port. What am I missing?

Re: Max OSX unable to connect to MySql DB

Posted: Fri Jan 14, 2011 9:01 pm
by adrian
Hello,

You'll need a JDBC driver for MySQL. You can find one here:
http://www.mysql.com/downloads/connector/j/

Don't use the Oxygen built-in MySQL data source, it's outdated. Instead configure a new Data Source in Oxygen by using the new JDBC driver:
http://www.oxygenxml.com/doc/ug-oxygen/ ... ource.html
Then create a new Connection and use the data source you have just created:
http://www.oxygenxml.com/doc/ug-oxygen/ ... ction.html

Regards,
Adrian