Manually creating a data source in CABI JasperServer for another DB, however, it throws an error in the test connection phase:
CABI JasperServer 7.1.1 or later
The root user being used to access the DB doesn't have privileges to do so.
You can login to the MySQL DB as an admin user and run the following to grant privileges to the root user:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY '<PASSWORD>' WITH GRANT OPTION;
However, this is not the regular way you would connect CABI JasperServer to Spectrum. We do not support any other data sources for CABI JasperServer other than Spectrum.