错误提示，大神忙帮看看怎么解决。

Question

android 通过jdbc连接Mysql运行错误

I/System.out: [socket][/10.110.169.248:40328] connected
I/System.out: close [socket][/10.110.169.248:40328]
W/System.err: java.sql.SQLException: Unknown system variable 'query_cache_type'
W/System.err: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
W/System.err: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
W/System.err: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
W/System.err: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
W/System.err: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
W/System.err: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2483)
W/System.err: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2441)
W/System.err: at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381)
W/System.err: at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:3790)
W/System.err: at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3227)
W/System.err: at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2235)
W/System.err: at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2017)
W/System.err: at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:779)
W/System.err: at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)
W/System.err: at java.lang.reflect.Constructor.newInstance0(Native Method)
W/System.err: at java.lang.reflect.Constructor.newInstance(Constructor.java:430)
W/System.err: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
W/System.err: at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)
W/System.err: at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
W/System.err: at java.sql.DriverManager.getConnection(DriverManager.java:569)
W/System.err: at java.sql.DriverManager.getConnection(DriverManager.java:219)
W/System.err: at com.example.administrator.myapplication1.Util.openConnection(Util.java:22)
W/System.err: at com.example.administrator.myapplication1.MainActivity$2$1.run(MainActivity.java:46)
W/System.err: at java.lang.Thread.run(Thread.java:761)
I/System.out: null
W/libEGL: [ANDROID_RECORDABLE] format: 1

Answer 1

应该是mysql版本和驱动版本不匹配，更换一个就ok了。建议从低一点的开始。