While installing CA Release Automation (All in One) with MySQL 8 we get the error "Failed to connect to database***"
Release : 6.4, 6.5, 6.6, 6.7
Component : CA RELEASE AUTOMATION RELEASE OPERATIONS CENTER
DB: MySQL 8
JDBC Connector: 5.1.21
As per recommendation with respect to MySQL, it is suggested to use connector MySQL 8.0.11 with MySQL. The error observed is due to the fact of using connector 5.1.21
Using MySQL 8 with MySQL Connector 5.1.21, results in below error
"Failed to connect to database. 'jdbc:mysql://127.0.0.1:3306/' for user 'root'. Unable to load"
1: MySQL 8 is not supported yet for 6.7 so please avoid using MySQL 8 and instead use supported MySQL version.
2: The connector version 8 will not be supported for 6.7 and hence you will have to use 5.1.** version of connector. An upgraded minor version like 5.1.46 is fine as we don't expect major change in minor version upgrades.
You can try JDBC connector version 5.1.46 as it seems to installed and works with MySQL 8. However, please note it can only be used for Test instance and not for any production/development instance as RA doesn't support MySQL 8 and 5.1.46 is not a recommended driver for MySQL 8 which can lead to unexpected future issues related to application and DB connectivity.
Note: Any issue reported for RA (version till 6.7) + MySQL 8 will fall under unsupported configuration matrix and will restrict us to provide any technical assistance on same.