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 connect to MySQL in Spectrum
Article ID: 186583
Updated On:
Products
CA Spectrum
CA eHealth
Issue/Introduction
Steps on how to connect to MySQL using the MySQL Command Line Client
Resolution
1. Navigate to $SPECROOT/mysql/bin
2. Type:
./mysql --defaults-file=../my-spectrum.cnf -uroot -proot
3. This will place you in the client at the mysql> prompt.
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.
2. Type:
./mysql --defaults-file=../my-spectrum.cnf -uroot -proot
3. This will place you in the client at the mysql> prompt.
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.
Feedback
Yes
No
Powered by
