After upgrading to 21.2.6, Report Manager is no longer starting properly.
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1290 (HY000) at line 26 in file: '/spectrum/Install-Tools/rpmgr/sql/srmdbapi/dcl/create_srmapi_user.sql': The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
Release : 21.2
Component : Spectrum Reporting
In later versions of MySQL, certain tasks and queries cannot be run with skip-grant-tables turned on. This is a security issue.
Therefore, this will need to be turned off in the $SPECROOT/mysql/my-spectrum.cnf file and processd restarted.