No sql root password set, can't connect to jdbc

Question

I've never set a password for Microsoft SQL server and when I log in, I log in with localhost, I just write . and it connects me. Now I am building an application in java and I have to connect to my database but since I've never set out a password, I am stuck

dataSource.setUrl("jdbc:mysql://localhost:3306/mpp");
        dataSource.setUsername("root");
        dataSource.setPassword(" _____ ");

What do I write as password?

pass an empty string.. nothing much needed just _setPassword("");_ — Viraj Nalawade, Apr 18 '16 at 11:27
Please update your tags correctly as to which server you are using!!! You have state its mySQL in the question but in comments below you state its Microsoft SQL Server? — Jacques Ramsden, Apr 18 '16 at 11:37

score 0 · Answer 1 · edited May 23 '17 at 12:24

0

You could setup your mySQL server with a password. Seen that it is best practice. You know security ans stuff :P

You wont be able to check what it is currently (depending on your install)

But you can reset it see the following answer here to reset for mySQL

Edit after your comment on using Microsoft SQL Server please see the answer here

edited May 23 '17 at 12:24

Community

1
1

answered Apr 18 '16 at 11:29

Jacques Ramsden

801
5
20

Problem is, I tried following the microsoft steps and I can't find my bin, I can't find anything. I have microsoft SQL server and everything is so messed up in the folder... – Mocktheduck Apr 18 '16 at 11:30
is there a way to check up my password? Maybe I have one? – Mocktheduck Apr 18 '16 at 11:31
Wait you said that you have mySQL server and in the comment above you say you have Microsoft SQL Server? Which one is it? – Jacques Ramsden Apr 18 '16 at 11:33

score 0 · Answer 2 · answered Apr 18 '16 at 11:33

0

change

 dataSource.setPassword(" _____ ");

to

 dataSource.setPassword("");

answered Apr 18 '16 at 11:33

Danyal Sandeelo

12,196
10
47
78

No sql root password set, can't connect to jdbc

2 Answers2