Mysql Connection with out password using corejava program

Question

I want to connect to a MySQL database. While installing MySQL I did not give any password, so in my program I did the same but I am getting error on connection. I am using properties file to get the driver, URL, username and password. Help me pleas.

This is my code:

try
{
    Class.forName("com.mysql.jdbc.Driver");
    con=DriverManager.getConnection("jdbc:mysql://localhost:3306/easylibdb1","root","");
} 
catch (Exception e) 
{
    System.out.println("Got Error While Connecting To Database...!");
    e.printStackTrace();
}

This is my properties file content:

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://192.168.1.51:3306/easylibdb1
user=root
password=""

i am getting like error: java.sql.SQLException: Access denied for user 'root'@'192.168.1.37' (using password: NO) — Rajesh Hatwar
– Rajesh Hatwar, Commented Jun 20, 2013 at 9:10

Rakesh · Accepted Answer · 2013-06-20 09:37:22Z

4

using password: NO - this means the program is not passing any password, in your case that is correct.

Since you mention that you are reading the values from the properties file, I don't see you doing that in the code you have posted. If you are really reading the values from the properties file in your actual code, and the MySQL server is a remote server, then make sure that you grant relevant permissions on the remote MySQL server with the below statement

grant all privileges on easylibdb1.* to 'root'@'192.168.1.51' to allow connections originating from 192.168.1.51

or

grant all privileges on easylibdb1.* to 'root'@'%' to allow connections originating from anywhere

answered Jun 20, 2013 at 9:37

Rakesh

4,3424 gold badges35 silver badges58 bronze badges

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

Comments

blackpanther · Accepted Answer · 2013-06-20 08:02:03Z

3

The password argument should be set to null because even an empty String "" implies that there is a password.

DriverManager.getConnection("jdbc:mysql://localhost:3306/easylibdb1","root",null)

answered Jun 20, 2013 at 8:02

blackpanther

11.5k12 gold badges53 silver badges79 bronze badges

Comments

JREN · Accepted Answer · 2013-06-20 08:00:23Z

2

Remove the 2 quotes after password in your properties file. So password=""should be password=

answered Jun 20, 2013 at 8:00

JREN

3,6204 gold badges29 silver badges46 bronze badges

1 Comment

Rajesh Hatwar Over a year ago

sorry i am stil geting this error : java.sql.SQLException: Access denied for user 'root'@'192.168.1.37' (using password: NO)

Andreas Dolk · Accepted Answer · 2013-06-20 08:12:41Z

2

Pass null as password instead of an empty String. That should make it work.

con = DriverManager.getConnection("jdbc:mysql://localhost:3306/easylibdb1","root",null);

From what I see right now, you're actually not using the values from the properties file.

edited Jun 20, 2013 at 8:12

answered Jun 20, 2013 at 7:59

Andreas Dolk

115k20 gold badges185 silver badges275 bronze badges

Comments

Joshua · Accepted Answer · 2013-06-20 07:57:49Z

0

If it's really password="" what stands in your properties file, then "" will be sent as password. Not an empty string but the two quote signs.

answered Jun 20, 2013 at 7:57

Joshua

2,9922 gold badges27 silver badges40 bronze badges

Comments

Andreas Dolk · Accepted Answer · 2013-06-20 08:11:08Z

0

URL=jdbc\:mysql\://192.168.1.51:3306/easylibdb1
USER=root
PASSWD=
DRIVER=com.mysql.jdbc.Driver

Please set ur PASSWORD Field as blank.. Don't put quote.

edited Jun 20, 2013 at 8:11

Andreas Dolk

115k20 gold badges185 silver badges275 bronze badges

answered Jun 20, 2013 at 8:04

sachin

1,4674 gold badges14 silver badges22 bronze badges

2 Comments

Rajesh Hatwar Over a year ago

ya i did that but still i am getting like java.sql.SQLException: Access denied for user 'root'@'192.168.1.37' (using password: NO)

sachin Over a year ago

So, you won't be access of the that particular IP address. Check the grant of the mysql. stackoverflow.com/questions/5016505/…

Tilak Raj · Accepted Answer · 2014-06-26 14:49:10Z

0

con = DriverManager.getConnection("jdbc:mysql://localhost:3306/easylibdb1","root",null);

answered Jun 26, 2014 at 14:49

Tilak Raj

4724 silver badges12 bronze badges

1 Comment

The Guy with The Hat Over a year ago

This answer turned up in the low quality review queue, presumably because you didn't explain the code. If you do explain it (in your answer), you are far more likely to get more upvotes—and the questioner actually learns something!

Chameera Dulanga · Accepted Answer · 2020-02-26 05:27:14Z

0

According to you, you are passing username as root and password as empty string.And your connection is established through

con=DriverManager.getConnection("jdbc:mysql://localhost:3306/easylibdb1","root","");

So change your function as

con=DriverManager.getConnection("jdbc:mysql://localhost:3306/easylibdb1","root",null);

Then it will work. Or change the password in the application.properties file as

password=

edited Feb 26, 2020 at 5:27

Chameera Dulanga

2285 silver badges19 bronze badges

answered Feb 16, 2020 at 15:50

Samaresh Maiti

11 bronze badge

Collectives™ on Stack Overflow

Mysql Connection with out password using corejava program

8 Answers 8

Comments

Comments

1 Comment

Comments

Comments

2 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

Comments

Comments

1 Comment

Comments

Comments

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related