Skip to content

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

Description

@LeonDragon

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

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions