Unknown initial character set index '255' received from server. Initial client character 解决方法

发布时间 2023-09-08 18:46:37作者: oktokeep

Unknown initial character set index '255' received from server. Initial client character 解决方法

mysql连接数据库时报此错误:

//String url = "jdbc:mysql://localhost:3306/mytest_db" 如果使用这句就会报错。
//Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
String url = "jdbc:mysql://localhost:3306/mytest_db?useUnicode=true&characterEncoding=utf8"; //改成这句,就可以了

#jdbc.mysql.className=com.mysql.jdbc.Driver
jdbc.mysql.className=com.p6spy.engine.spy.P6SpyDriver
#jdbc.mysql.url=jdbc:mysql://127.0.0.1:3306/mytest_db?useUnicode=true&characterEncoding=utf-8
##&修改成& 可以解决报错
jdbc.mysql.url=jdbc:mysql://127.0.0.1:3306/mytest_db?useUnicode=true&characterEncoding=utf-8
jdbc.mysql.user=test
jdbc.mysql.password=test

jdbc.dbcp.maxActive=30
jdbc.dbcp.maxIdle=16
jdbc.dbcp.maxWait=10000
jdbc.dbcp.defaultAutoCommit=true
jdbc.dbcp.removeAbandoned=true
jdbc.dbcp.removeAbandonedTimeout=60
jdbc.dbcp.logAbandoned=true