Connecting to MySQL database error in Java

Question

I have a java code and I am connecting to the mysql database with the following connection string.

 String userName = "admin";
 String password = "pass";
 String url = "jdbc:mysql://<my IP>/dbase"; //not localhost
 Class.forName ("com.mysql.jdbc.Driver").newInstance ();
 conn = DriverManager.getConnection (url, userName, password);

When I make a JAR (Runnable JAR through eclipse), and take it to another machine in the same network I get an error

Access denied for user 'admin'@'<another machine IP' (using password: YES) //not localhost

The IP magically changed to another machine IP when I take the JAR to another machine. admin user has all privileges possible.

Whats wrong? Please help !!

You are trying to access the database from the other machine ip. Therefore the error is correct. Is your MySQL server configured to allow access from that IP? — Ricardo Marimon
– Ricardo Marimon, Commented Jan 11, 2012 at 1:59
why is that root is on the error message where in fact userName = admin? even if it changes its IP, the username will still be admin not root. — John Woo
– John Woo, Commented Jan 11, 2012 at 2:00
@thinksteep yes I have hardcoded the IP in my program. The IP changes in the other machine — Ank
– Ank, Commented Jan 11, 2012 at 2:14

Brian Roach · Accepted Answer · 2012-01-11 02:27:04Z

4

The IP address listed in the error message is the IP address of the machine your program is running on. It's telling you that you're not allowed to connect to MySQL from that IP address as root

You will need to talk to the person who configures/administers your MySQL database. More than likely this is an intentional security measure.

edited Jan 11, 2012 at 2:27

answered Jan 11, 2012 at 2:01

Brian Roach

77k12 gold badges140 silver badges164 bronze badges

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

1 Comment

Ank Over a year ago

Thanks Brian. I am sure this is the problem. I'll consult my DBA tomorrow

BalusC · Accepted Answer · 2012-01-11 02:42:58Z

2

Maybe you should run the below command.

grant all privileges on *.* to 'admin'%'@' identified by 'pass';
flush privilges;

edited Jan 11, 2012 at 2:42

BalusC

1.1m377 gold badges3.7k silver badges3.6k bronze badges

answered Jan 11, 2012 at 2:38

Eric.Sun

401 bronze badge

Comments

vinoth · Accepted Answer · 2012-01-11 04:37:52Z

0

I think There is no problem with your Java code. Also try to connect the mysql server from command prompt

mysql -u root -h <ip address> -p

If you got the same error then the possible reason would be 1. In correct password 2. Permission is denied to access via network

You can give permission using below command

GRANT ALL ON db.* to root@'ip' IDENTIFIED BY 'PASSWORD';

answered Jan 11, 2012 at 4:37

vinoth

4713 gold badges7 silver badges15 bronze badges

Collectives™ on Stack Overflow

Connecting to MySQL database error in Java

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related