How to login to Spectrum MySQL CLI Client

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

How can we access the mysql client?

Environment

Current supported releases

Resolution

NOTE: 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;