The my-spectrum.cnf file is located in the $SPECROOT/mysql directory. To resolve the issue, login into mysql from the $SPECROOT/mysql/bin directory using the following command:
./mysql --defaults-file=../my-spectrum.cnf -uroot -proot
NOTE: This command can also be used from a bash shell on a Spectrum install on Windows.