File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
JDBC Fails on GRANT Command
Joined: Apr 03, 2013
Apr 03, 2013 23:29:53
Following command from mysql command prompt works fine but doesn't works from JDBC
grant replication slave on *.* to 'replication_user'@'%' identified by 'password';
mysql> grant replication slave on *.* to 'replication_user'@'%' identified by 'password';
Query OK, 0 rows affected (0.03 sec)
JDBC returns Exception as below
"Access denied for user 'root'@'%' (using password: YES)"
JDK Version 1.7
any help will be appreciated
Joined: Oct 27, 2005
Apr 04, 2013 12:08:33
root != replication_user
SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6 - OCEJPAD 6
How To Ask Questions
How To Answer Questions
I agree. Here's the link:
subject: JDBC Fails on GRANT Command
How to prevent a user from dropping tables
connection to Mysql with username and password
How to prevent a MySQL slave accepting queries?
Check status of MySQL replication with JDBC
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015