Create a read only user for the Reporting Database

Products

• DX NetOps
• CA Spectrum

Issue/Introduction

How to create a mysql read only user to run queries against the reporting database. 

Environment

DX NetOps Spectrum. All releases.

 

Resolution

Navigate to the $SPECROOT/mysql/bin directory on the report manager server and run the following command to login to the mysql database.

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

From the mysql prompt, run the following commands.

1. CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
2. GRANT SELECT ON reporting.* TO 'newuser'@'localhost';
3. FLUSH PRIVILEGES;