When trying to connect to MySQL or run a mysql application, the following error is presented:
$ ./mysql --defaults-file=../my-spectrum.cnf -uroot -proot
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
CA Spectrum Release : 10.3.x, 10.4.x
$SPECROOT/mysql/bin
./mysql --defaults-file=../my-spectrum.cnf -uroot -p<PASSWORD>
GRANT ALL on reporting.* to 'userid'@'localhost';
flush privileges;