Getting error in executeUpdate Java MySQL

Question

I trying to set "ALL PRIVILEGES" from Java on remote MySQL database test and user test . Here is snippet of my code:

Class.forName("com.mysql.jdbc.Driver");
Connection con = null;
con = (Connection) DriverManager.getConnection("jdbc:mysql://xx.xxx.xxx.xx:3306/?user=root&password=pswrd");

Statement st = con.createStatement();
int res = st.executeUpdate("GRANT ALL PRIVILEGES ON test.* TO 'test'@'%' IDENTIFIED BY '12345';");

Nothing extraordinary. All queries from root user work fine, but in this partucular case I'm getting error:

Exception in thread "main"   com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'root'@'%' to database 'test'

What did I do wrong?

UPDATE

Here's answer. So, the problem wasn't solved ...

How come the user name reads 'root'@'%'?

randominstanceOfLivingThing
– randominstanceOfLivingThing

2016-04-24 17:10:23 +00:00
Commented Apr 24, 2016 at 17:10 — randominstanceOfLivingThing
– randominstanceOfLivingThing, Commented Apr 24, 2016 at 17:10
Please include the stacktrace of the exception.

Mark Rotteveel
– Mark Rotteveel

2016-04-25 07:51:03 +00:00
Commented Apr 25, 2016 at 7:51 — Mark Rotteveel
– Mark Rotteveel, Commented Apr 25, 2016 at 7:51

Sanjeev · Accepted Answer · 2016-04-24 17:10:34Z

0

Try establishing connection with

DriverManager.getConnection("jdbc:mysql://hostname:port/dbname","username", "password");

answered Apr 24, 2016 at 17:10

Sanjeev

9,9762 gold badges24 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mateusz Stefaniak · Accepted Answer · 2016-04-24 17:13:34Z

0

Please make sure that 'root@yourHost' (especially from yourHost) indentified by 'pswrd' has rights to manage privileges on this database.

edited Apr 24, 2016 at 17:13

answered Apr 24, 2016 at 17:12

Mateusz Stefaniak

9051 gold badge10 silver badges20 bronze badges

Comments

Zeeshan Bin Iqbal · Accepted Answer · 2016-04-24 17:15:03Z

0

try adding host like this 'test'@'yourhost'

answered Apr 24, 2016 at 17:15

Zeeshan Bin Iqbal

1,2962 gold badges8 silver badges8 bronze badges

1 Comment

m02ph3u5 Over a year ago

A little explanation would improve the quality of your answer.

Collectives™ on Stack Overflow

Getting error in executeUpdate Java MySQL

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related