Search code examples
mysqljmeterdatabase-connectionworkbench

JMETER - MYSQL Workbench Cannot create PoolableConnectionFactory (Unknown character set index for field '255' received from server.)

I am using MySQL Workbench 8.0.18 previously I have installed latest version 8.0.19. enter image description here I have added the connectors in \apache-jmeter-5.1.1\lib enter image description here

If I enter incorrect password then I get this error -- which is expected and correct - Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))

And If I put incorrect db then I get this enter image description here

This suggest JMeter is able to connect with MYSQL Workbench but keep getting the error Cannot create PoolableConnectionFactory (Unknown character set index for field '255' received from server.) enter image description here

I am able to connect to other MYSQL DB on cpanel DB with pretty much same connection strings.

Please help

enter image description here

This is what my JMETER JDBC Connection String enter image description here

Solution

  • It was just a conflicting jar file of JDBC.jar was in my lib folder not sure why I needed and used for but as soon as I removed it connected successfully.

    enter image description here