Unable to log into MySQL on any SpectroSERVERs

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

When trying to log into the MySQL db on any SpectroSERVER (using the "ddmdb" database) I get the following error:

ERROR 1045 (28000):  Access denied for user 'root'@'localhost' (using password: YES)

The syntax I am using is as follows:

FROM THE $SPECROOT/mysql/bin/ directory:

$ ./mysql.exe --defaults-file=../my-spectrum.cnf -uroot -proot

Environment

Release : 21.2.8
Component: Archive Manager/MySql

Cause

Starting from DX NetOps Spectrum 21.2.4, the default root password for MySql is "MySqlR00t". For DX NetOps Spectrum versions prior to 21.2.4, the default root password is "root".

Resolution

Since this customer is running 21.2.8, use "MySqlR00t" as the MySql password for the root user.

$ ./mysql.exe –defaults-file=$SPECROOT/mysql/my-spectrum.cnf -uroot -pMySqlR00t ddmdb -A