cPanel Question posted in
The official documentation can be seen here.

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

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.1lib
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

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    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


  2. 0

    Execute SHOW VARIABLES command to view character_set_client and character_set_connection variables values:

    SHOW VARIABLES LIKE 'char%';

    enter image description here

    and make sure that your characterEncoding is matching Java encoding

    If you’re absolutely sure that your connection string is fine then try do upgrade to the latest version of the Connector/J

    More information: MySQL Database and JMeter – How to Test Your Connection

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search