processquerying/PQL

Caused by: java.sql.SQLException: Access denied for user 'pql_master'@'localhost' (using password: YES)

LeonDragon opened this issue · 0 comments

I have followed the instruction for running the PQL. After installing MySQL and configure the pql_master user and password. I encountered the below error. Even I try to grant permission, the problem still exists. Could you please help me? Thank you very much

MySQL Shell granting access.
MySQL SQL > \connect pql_master@localhost
Creating a session to 'pql_master@localhost'
Fetching schema names for autocompletion... Press ^C to stop.
Your MySQL connection id is 62
Server version: 5.7.28-log MySQL Community Server (GPL)
No default schema selected; type \use to set one.
MySQL localhost:3306 ssl SQL > \use pql
Default schema set to pql.
Fetching table and column names from pql for auto-completion... Press ^C to stop.
MySQL localhost:3306 ssl pql SQL > grant all on . to 'pql_master'@'%' identified by '123456' with grant option;
Query OK, 0 rows affected, 1 warning (0.0006 sec)
Warning (code 1287): Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement.
MySQL localhost:3306 ssl pql SQL > flush privileges;
Query OK, 0 rows affected (0.0020 sec)
MySQL localhost:3306 ssl pql SQL > show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| pql |
| sys |
+--------------------+
5 rows in set (0.0006 sec)
MySQL localhost:3306 ssl pql SQL >

PQL Error output =========

F:\PQL>java -jar PQL.BOT-latest.jar --name=Brisbane --sleep=5

Exception in thread "main" java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.jdt.internal.jarinjarloader.JarRsrcLoader.main(JarRsrcLoader.java:58)
Caused by: java.sql.SQLException: Access denied for user 'pql_master'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:927)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1709)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1252)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2486)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2519)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2304)
at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:834)
at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.jbpt.persist.MySQLConnection.connect(MySQLConnection.java:63)
at org.jbpt.persist.MySQLConnection.(MySQLConnection.java:29)
at org.pql.bot.PQLBotCLI.main(PQLBotCLI.java:98)
... 5 more