I am trying to move my application from Godaddy hosting to AWS using AWS lightstail on a Linux/UNIX BITNAMI instance running on Apache server.
All the files and database have been migrated successfully to my new AWS instance and SSL certificate was successfully created using LetsEncrypt (CERTBOT) .
My Yii framework version is 1.1.17 and MySQL version on Godaddy PhpMyAdmin 5.6.43 and the application is working just fine with no connection issue .
When trying to migrate to AWS I am using AWS MySQL database (8.0.21) and was able to connect successfully to my DB with MySQL workbench but for some reason I am unable to access my site . I get error : yoursite is currently unable to handle this request.
HTTP ERROR 500.
Looking at the error logs it looks like an issue with the Yii FrameworkPHP Fatal error: Uncaught CDbException: CDbConnection failed to open the DB connection. in /opt/bitnami/apache/htdocs/yiiframework/db/CDbConnection.php
Is this an issue with MySQL 8 not being compatible with Yii 1.1.17 , if so how to resolve this issue ?
I would appreciate your help !