Can't Connect to Database

[NaheelSalman]

I have created Database , As well setup the project with jdbc
but still it can't connect with mysql server
i have tried using
user4, test123 or Test123
but failed to connect and get this error in my console screen:
java.sql.SQLException: Unable to load authentication plugin 'caching_sha2_password'. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:923) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at com.inventory.database.ConnectionFactory.<init>(ConnectionFactory.java:26) at com.inventory.ui.LoginDialog.loginBttnMouseClicked(LoginDialog.java:193) at com.inventory.ui.LoginDialog.access$1(LoginDialog.java:187) at com.inventory.ui.LoginDialog$2.mouseClicked(LoginDialog.java:68)

[NaheelSalman]

Solution of jbdc Error Log:
here are two links
first read this article if you want concepts Click Here
then go and download this jar file and extract your mysql java connector on your environment Click Here

[NaheelSalman]

Finally i got error and
You have used MD5 encryption method and the password stored in hashed form for test123 in ims.sql is wrong
its 'cc03e747a6afbbcbf8be7668acfebee5' = test123
i'm going to fork that issue

[sajxraj]

Hi NaheelSalman, Glad that you have solved the issue. Frankly speaking, this project was done in my college days and I do not maintain it. The reason I did not dig into the issue is I need to set up everything from scratch as I don't do Java nowadays. However, if you have any fixes or ideas, you can contribute to this project. Many thanks, Sajan Rajbhandari

…

On Sat, Nov 7, 2020 at 3:30 PM NaheelSalman ***@***.***> wrote: Finally i got error and You have used MD5 encryption method and the password stored in hashed form for test123 in ims.sql is wrong its *'cc03e747a6afbbcbf8be7668acfebee5' = test123* i'm going to fork that issue — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#7 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABYT6EC3DDFIDYZ4OPZLHBLSOUJMTANCNFSM4TJZKASQ> .

[sajxraj]

Just out of curiosity though, what are you using this application for?

…

On Mon, Nov 9, 2020 at 7:11 PM Sajan Rajbhandari ***@***.***> wrote: Hi NaheelSalman, Glad that you have solved the issue. Frankly speaking, this project was done in my college days and I do not maintain it. The reason I did not dig into the issue is I need to set up everything from scratch as I don't do Java nowadays. However, if you have any fixes or ideas, you can contribute to this project. Many thanks, Sajan Rajbhandari On Sat, Nov 7, 2020 at 3:30 PM NaheelSalman ***@***.***> wrote: > Finally i got error and > You have used MD5 encryption method and the password stored in hashed > form for test123 in ims.sql is wrong > its *'cc03e747a6afbbcbf8be7668acfebee5' = test123* > i'm going to fork that issue > > — > You are receiving this because you are subscribed to this thread. > Reply to this email directly, view it on GitHub > <#7 (comment)>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/ABYT6EC3DDFIDYZ4OPZLHBLSOUJMTANCNFSM4TJZKASQ> > . >

[NaheelSalman]

Welcome well i m collecting some demos to show to my sir for management systems for that i used it
obviously i can't code from scratch if i have ability to read others code :)
and i appreciate your work ! 🥇