Myeclipse database Browser connection error: OPTION SQL _SELECT_LIMIT = DEFAULT, myeclipse
(1) because the latest mysql version was updated to mysql5.6 some time ago, the following error occurs when editing data using myeclipse's DB Browser:
(2) check on the network is the original, because the mysql driver jar version is low; previously used mysql driver is mysq-connector-java-5.0.8-bin.jar, at the time of development, we will send the test statement set option SQL _SELECT_LIMIT = DEFAULT when creating the database. The above shows that MySQL does not support this statement, so an error is reported. An error occurs when the driver cannot keep up;
(3) the solution is simple: update the driver's jar program to the latest version:
You can download the latest driver for free:
Http://dev.mysql.com/doc/relnotes/connector-j/en/news-5-1.html
Or my online drive: http://yunpan.cn/cA7GrYZPRVDx9 extract code ecbe
In addition, you can find a status table for each driver file version on the Internet.