mysql - Jmeter showing error : Cannot create PoolableConnectionFactory (Access denied for user 'shubham@localhost'@'118.185.61.226' (using password: YES))

Question

When i have created a JDBC request sampler in jmeter and used jmeter connection configuration element and when i try to create a connection with DB following error is showing again and again can anyone please give me resolution for this?

Error : Cannot create PoolableConnectionFactory (Access denied for user 'shubham@localhost'@'115.248.185.130' (using password: YES))

I am also attaching the screenshot of the error :

Configuration element screen shot :

Can anyone please help me resolving this issue ?

Answer 1

It is more about MySQL configuration rather than JMeter. The error you're getting means that shubham user is not allowed to connect from 115.248.185.130 host.

So:

1. First of all you have incorrect JDBC URL, looking into Connection URL Syntax it should be in form of:

   protocol//[hosts][/database][?properties]
   

   most probably you need to remove phpmyadmin from your URL

2. Execute the following query on MySQL server side:

   GRANT ALL ON ipofDB.* TO shubham@'%' IDENTIFIED BY 'your password' WITH GRANT OPTION;
   

   This will allow access not only from localhost and 115.248.185.130, but also from any other host just in case you will go for Distributed Testing

References:

• MySQL: Adding User Accounts
• MySQL Database and JMeter - How to Test Your Connection