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:

• Jmeter Error java.net.BindException: Address already in use: connect
• Mybatis Connect Database Error: Error querying database. Cause: java.sql.SQLException: The server time zone value..
• jmeter Execute to create Chart Error: An error occurred: Error while processing samples: Mismatch between ……
• ArchLinux starts error after modifying MariaDB database path Can’t create test file /xxxxx/xxxxx-test
• [Solved] dbeaver Connect clickhouse Error: Unexpected driver error occurred while connecting to the database
• JMeter JDBC Error: No pool found named: ‘test‘ [How to Solve]
• [Solved] JMETER pressure measure with a lot of Ports Error: 504GATEWAY TIMEOUT
• [Solved] Android Room: Database Common Error ‘missing database’
• [Solved] com.alibaba.druid.pool.DruidDataSource – create connecti
• How to Solve jmeter Install Error (Three Common Errors)
• [Solved] JMeter Server Command line pressure measurement: Error in NonGUIDriver java.lang.IllegalArgumentException
• Creating test database for alias ‘postgres’… Got an error creating the test database: permission
• [Solved] XML file configuration database connection information logical symbol error
• [Solved] Error: failed to create deliver client: orderer client failed to connect to orderer.example.com:7050
• Jmeter not-GUI Run Error: Error generaing the report:java.langNullPointerException
• [Solved] jedis Connect redis Error: connect timed out
• [Solved] Jmeter Error: Error loading results file – see file log
• Springboot connects to the database error: testWhileIdle is true, validationQuery not set
• Database App.config configurate file Error & Solution
• ORA-12505 error when java connects to oracle database