search

Home >Database >Mysql Tutorial >MySQL 连接问题

MySQL 连接问题

WBOY
WBOYOriginal
2016-06-07 15:46:541231browse

服务器centOS，数据库为MySQL 远程登录，使用shell登录MySQL，一切正常。 使用DbVisualizer登录，表结构显示正常，但是数据不能正常显示，报错 Error code 1064, SQL state 42000: You have an error in your SQL syntax; MySQL server version for the righ

服务器centOS，数据库为MySQL

远程登录，使用shell登录MySQL，一切正常。

使用DbVisualizer登录，表结构显示正常，但是数据不能正常显示，报错

Error code 1064, SQL state 42000: You have an error in your SQL syntax;MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=1000'

上网发现是jdbc驱动的问题，遂下载mysql-connector-java-5.1.25-bin.jar

放入，D:\DbVisualizer-6.0.7\jdbc\mysql文件夹下，数据显示正常

我的资源里有

mysql-connector-java-5.1.23-bin.jar可供下载，测试可用

Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql完整新约束Next article：MySQL用户权限

Related articles

See more