How to connect to MySQL in Spectrum

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

Steps on how to connect to MySQL using the MySQL Command Line Client

Resolution

NOTE: 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". In the following MySql commands, replace <PASSWD> with the root password for your DX NetOps Spectrum version.

- Log into the system as the user that owns the Spectrum installation

- If on Windows, start a bash shell by running "bash -login"

- cd to the $SPECROOT/mysql bin directory and enter the following command:

./mysql --defaults-file=../my-spectrum.cnf -uroot -p<PASSWD>

At this point you can execute queries as needed.  Change databases using the "use" command.
I.e. "use ddmdb" or "use reporting"

Please note that any changes made using the client should come from Support or Engineering.  Any changes made in here will not be supported otherwise.