How to login to Spectrum MySQL CLI Client

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

How can we access the mysql 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.

1. Log into  the system as the user that owns the Spectrum installation

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

3. cd to the $SPECROOT/mysql/bin and enter the following command to log into mysql:

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

4. Once logged in you can "use <database>" depending on what system you are on.

 

OneClick/SRM:

use reporting;

 

SS/DDM:

use ddmdb;