ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How to login to Spectrum MySQL CLI Client

book

Article ID: 133030

calendar_today

Updated On:

Products

CA Spectrum DX NetOps

Issue/Introduction

How can we access the mysql client?

Resolution

1. Open a bash shell if Windows, or terminal if Linux.

2. Navigate to $SPECROOT/mysql/bin

3. Type:

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


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


OneClick/SRM:

use reporting


SS/DDM:

use ddmdb