Failure to connect to the database when starting the server

Development
#1

Hi, When I start the OpenMRS server and try to access it through the browser, this noification is flagged: ???Unable to connect to database???

???User account root does not work. Could not create connection to database server. Attempted reconnect 3 times. Giving up. See the error log for more details???

The error log in my terminal has been shared here: Error logs - Pastebin.com

Please help with resolution.

#2

Basing on the logs am seeing the error is Caused by: java.sql.SQLException: Unable to load authentication plugin 'caching_sha2_password'. this implies you are using wrong mysql_connector to solve this:

1.You need just to delete your older connector and download new version mysql-connector-java or

2.Starting with MySQL 8.0.4, they have changed the default authentication plugin for MySQL server from mysql_native_password to caching_sha2_password** . So Just run this command and your issue will be solved: ALTER USER ‘your_username’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘your_new_pass’; Hopefully either of the 2 will help solve the issue.

#3

This was resolved. Thanks Juliet.

1 Like
#4

@ananungi you can actually share what helped you on this link

#5

I downgraded my mysql server to 5.6 but maintained other mysql services like connector at 8.0. I didn’t try Juliet’s solution because I saw it after the issue resolved.