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.
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.
This was resolved. Thanks Juliet.
@ananungi you can actually share what helped you on this link
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.