Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
LeonDragon opened this issue Apr 9, 2020 · 0 comments

Comments

@LeonDragon
Copy link

LeonDragon commented Apr 9, 2020

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant