Oneclick SRM migration not working

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)

 

Environment

Release : 21.2

Component : Spectrum Reporting

Cause

Grant All Privileges with Grant option.

Resolution

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

FLUSH PRIVILEGES;