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.

Oneclick SRM migration not working

book

Article ID: 241248

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

Need to migrate a oneclick reporting database.

However, the procedure does not seem to work.

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/spectrum/21-2/installing-and-upgrading/install-report-manager/install-oneclick-with-report-manager.html

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.251.252.14' IDENTIFIED BY 'MySqlR00t';

This gives: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

 

Cause

Grant All Privileges with Grant option.

Environment

Release : 21.2

Component : Spectrum Reporting

Resolution

GRANT ALL PRIVILEGES ON `%`.* TO 'root'@'10.251.252.14'  WITH GRANT OPTION;

FLUSH PRIVILEGES;