Jmeter显示错误:无法创建PoolableConnectionFactory(对用户'shubham @ localhost'@'118.185.61.226'的访问被拒绝(使用密码:是)) [英] Jmeter showing error : Cannot create PoolableConnectionFactory (Access denied for user 'shubham@localhost'@'118.185.61.226' (using password: YES))
问题描述
当我在jmeter中创建了一个JDBC请求采样器并使用了jmeter连接配置元素时，当我尝试与DB建立连接时，以下错误又一次显示出来了，有人可以为我解决这个问题吗?
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?
错误:无法创建PoolableConnectionFactory(对用户'shubham @ localhost'@'115.248.185.130'(使用密码:是)的访问被拒绝)
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 :
配置元素屏幕截图:
任何人都可以帮助我解决此问题吗?
Can anyone please help me resolving this issue ?
推荐答案
它更多地是关于MySQL配置而不是JMeter.您收到的错误意味着不允许shubham用户从115.248.185.130主机进行连接.
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.
所以:
-
首先，您有错误的JDBC URL，请查看最有可能需要从URL中删除
phpmyadminmost probably you need to remove
phpmyadminfrom your URL在MySQL服务器端执行以下查询:
Execute the following query on MySQL server side:
GRANT ALL ON ipofDB.* TO shubham@'%' IDENTIFIED BY 'your password' WITH GRANT OPTION;这不仅允许从localhost和
115.248.185.130进行访问，而且还允许从任何其他主机进行访问，以防万一您需要使用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参考文献:
- MySQL: Adding User Accounts
- MySQL Database and JMeter - How to Test Your Connection
这篇关于Jmeter显示错误:无法创建PoolableConnectionFactory(对用户'shubham @ localhost'@'118.185.61.226'的访问被拒绝(使用密码:是))的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
