Portal won't start after resetting mysql server - Error : liquibase.exception.DatabaseException: Connection could not be created to jdbc:mysql - Plugin 'mysql_native_password' is not loaded

Products

• CA API Developer Portal

Issue/Introduction

After maintenance on the Windows system and after restarting windows with MySQL, the CA Portal does not initialize.

The database was checked and no locked tables were found in MySQL. Connection between CA portal and MySQL is ok.

When starting ./portal.sh, it is in staring and looking at the log via docker service logs -f portal_db-upgrade, the following is observed:

[email protected]    | Unexpected error running Liquibase: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: Connection could not be created to jdbc:mysql://address=(protocol=tcp)(type=master)(host=myhostname.example.com)(port=3306)/portal?createDatabaseIfNotExist=true&failOverReadOnly=false&serverTimezone=UTC with driver com.mysql.cj.jdbc.Driver.  Plugin 'mysql_native_password' is not loaded

Environment

CA Dev Portal 5.2.3

Windows Server running MySQL 8.4 

Cause

The my.ini file did not have mysql_native_password=ON set to the parameter was disabled. The Windows Update/reboot appears to have altered the my.ini file back to its default values.

Resolution

1. Edit the my.ini file located  ie :C:\ProgramData\MySQL\MySQL Server 8.4\  on the Windows Server

2. The server-side plugin is built into the server, but is disabled by default. To enable it, include mysql_native_password=ON under the [mysqld] section of your MySQL configuration file.

3. Save the my.ini file

4.  Restart the MySQL Service from Task Manager

5.  Check Firewall Rules from Linux and Windows to allow Portal UI to be accessible for user login