processquerying
Caused by: java.sql.SQLException: Access denied for user 'pql_master'@'localhost' (using password: YES)
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 frompqlfor 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.
