JDBC MySQL connection without specifying password

Question

Is it possible to connect to a MySQL database without specifying the username and password in Java code :

Connection con=DriverManager.getConnection("database url","username","password");

or is there any way to change the username and password using Java?

You seem to be asking two completely different things here: 1) Unauthenticated login; 2) password changing. Which are you interested in? — Jon Skeet
– Jon Skeet, Commented Feb 6, 2013 at 14:54
@JonSkeet For the first preference : unauthenticated login and if it is not possible then password changing. — Shivam Arora
– Shivam Arora, Commented Feb 6, 2013 at 14:57
Well is your server set up for unauthenticated login? I don't even know if that's possible, but if you haven't configured it that way, I would really hope that it would prevent you from performing unauthenticated access in JDBC. Configuring the server is the first job here. — Jon Skeet
– Jon Skeet, Commented Feb 6, 2013 at 14:58
@JonSkeet i just want that when i run my program on any other computer having a different mysql password,my program should run on it. Is there any way to do so? — Shivam Arora
– Shivam Arora, Commented Feb 6, 2013 at 15:01
I'd certainly hope not. The whole point of having a username and password is to secure the data against people who don't have the password. Do you mind if I log into your email account without a password, for example? If you need to access the data, your program should allow the password to be specified somehow (e.g. through a UI, or possibly a command line argument) — Jon Skeet
– Jon Skeet, Commented Feb 6, 2013 at 15:03

Matthew Goff · Accepted Answer · 2016-07-28 09:00:48Z

2

There is another method of the same name to connect anonymously (without username or password):

Connection con=DriverManager.getConnection("database url");

Source: https://docs.oracle.com/javase/7/docs/api/java/sql/DriverManager.html

answered Jul 28, 2016 at 9:00

Matthew Goff

213 bronze badges

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

Comments

CodeChimp · Accepted Answer · 2013-02-06 15:36:37Z

1

I don't know if you can setup a default user, but you can most certainly set up a user with no password.

As for the second question, assuming your connection has adequet rights in MySQL, you can most certainly set the password on any user. The most basic way to do that is to do:

update user set password=password('new_pass') where user = 'someuser';

Optionally you may want to specify the host field as well in the where clause. This needs to be ran in the msql database.

answered Feb 6, 2013 at 15:36

CodeChimp

8,1946 gold badges45 silver badges80 bronze badges

2 Comments

Shivam Arora Over a year ago

I think i have to make a connection with a mysql database first to be able to do this with java. But the connection will fail if I don't have the right username and password. Can I do this before making any connection with a mysql database in Java?

CodeChimp Over a year ago

Java is making a "connection", so no, you don't have to manually connect to your DB first. As long as the credentials are correct, the JDBC drivers should be able to connect just fine. However, this assumes you have the correct credentials. MySQL has fairly granular security, allowing you to specify down to which host a user can connect from. I do not believe you can provide an empty user, as requested, but you can provide a null password. This link explains how to create accounts, and has an example of an account with no password: dev.mysql.com/doc/refman/5.0/en/create-user.html

Collectives™ on Stack Overflow

JDBC MySQL connection without specifying password

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related