Recently, you have encountered such a problem in JMeter connection database:

Response message:java.sql.SQLException: Cannot create PoolableConnectionFactory (Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.)

 

The reason for this error is the coding problem, as shown in the following figure:

Modify the Database URL in JDBC Connection Configuration to

jdbc:mysql://127.0.0.1:{port_number}/{db_name}?useUnicode=true&characterEncoding=utf8

For example: jdbc:mysql://127.0.0.1:3306/stu?useUnicode=true&characterEncoding=utf8

The problem is solved~

Read More:

• [Solved] JDBC error: Communications link failure
• [Solved] com.alibaba.druid.pool.DruidDataSource – create connecti
• How to Solve Logstash error: failed to execute action
• [Solved] Error creating bean with name ‘braveHttpServerHandler‘ defined in class path
• How to Solve “Error db.num is null” when starting Nacos
• JMeter JDBC Error: No pool found named: ‘test‘ [How to Solve]
• [Solved] Error: ER_ACCESS_DENIED_ERROR: Access denied for user ‘root’@‘localhost’ (using password: YES)
• [Solved] MariaDB Add Datas Error: SQL error [1366] [22007]: (cIncorrect string value: ‘\xE5\xBC\xA0\xE4\xB8\x89’ for column
• [Solved] XML file configuration database connection information logical symbol error
• Node.js operation mysql error Cannot enqueue Handshake after invoking quit
• [Solved] Schema initialization FAILED Metastore state would be inconsistent
• [Solved] IO Error: The Network Adapter could not establish the connection
• [Solved] SpringBoot integration with Redis error: java.net.ConnectException: Connection refused: no further information
• com.alibaba.druid.pool.DruidDataSource error Warning: init datasource error
• [Solved] MYSQLD: Can‘t create directory ‘/usr/local/mysql/data/’(Errcode:2 -No such file or directory)
• Initial installation of hive-2.1.0 startup error problem solution
• Spring Boot Druid Error: discard long time none received connection
• [Solved] Error creating bean with name ‘enableRedisKeyspaceNotificationsInitializer‘ defined in class path re
• Springboot connects to the database error: testWhileIdle is true, validationQuery not set
• ArchLinux starts error after modifying MariaDB database path Can’t create test file /xxxxx/xxxxx-test