Java MariaDB connection error: Access denied for user 'root'@'localhost'

Asked May 02 '20 at 09:23

Active May 02 '20 at 17:13

Viewed 232 times

I can't start my program, because whenever I try to open the datebase connection with my MariaDB I get this error.

java.sql.SQLException: Could not connect: Access denied for user 'root'@'localhost' (using password: YES) Caused by: org.mariadb.jdbc.internal.common.QueryException: Could not connect: Access denied for user 'root'@'localhost' (using password: YES)

I tried to reboot my computer, restart MariaDB, even reinstalling MariaDB, but none of them worked. Interestingly I can somehow connect to the database with HeidiSQL. It's funny, because last time I had the same problem and I couldn't connect with HeidiSQL either. The solution was simple, I had to restart MariaDB, but now it doesn't work.

I'm using Windows 10, Java 14, MariaDB 10.4. This seems important as I've checked on all related issues and I still couldn't solve the problem.

Has anyone faced with this this issue before?

edited May 02 '20 at 17:13

Mark Rotteveel

100,966
191
140
197

asked May 02 '20 at 09:23

Zoltán Szatmáry

Can you connect using the command line `$ mysql -u root -p` ? – 0xh3xa May 02 '20 at 09:30
I can connect to it. – Zoltán Szatmáry May 02 '20 at 09:32
Strange! could you try this solution: https://stackoverflow.com/questions/6445917/connect-failed-access-denied-for-user-rootlocalhost-using-password-yes – 0xh3xa May 02 '20 at 09:34
Hm... Even stranger! I tried that yesterday, but it didn't work then, but now it looks like it worked. Thanks! – Zoltán Szatmáry May 02 '20 at 09:50
Lol :D some time happens – 0xh3xa May 02 '20 at 10:10

Java MariaDB connection error: Access denied for user 'root'@'localhost'

0 Answers0