Re: Error while connecting Eclipse and MySQL

[Todd Farmer]

Hi Rosy,

It sounds that you're having the same problem reported here:

http://forums.mysql.com/read.php?39,609121,610173#msg-610173

You are likely using an older release of MySQL Connector/Java with a MySQL 5.6 Server. This combination won't work, as older versions of Connector/Java issue "SET OPTION" commands as part of connection set-up activities. This syntax was deprecated a while back, and removed from MySQL Server 5.6. To avoid this problem, you need to upgrade your MySQL Connector/Java library to at least 5.1.20, or use a MySQL Server version earlier than 5.6.

Hope that helps.

--
Todd Farmer
MySQL @ Oracle
http://www.oracle.com/mysql/