Problems restoring the netqosportal and em databases

Document ID : KB000100227
Last Modified Date : 05/06/2018
Show Technical Document Details
Issue:
When I try to restore the netqosportal database on a CAPC console, I get the following error:

[root@capcserver]# mysql netqosportal -e 'source /tmp/netqosportal.sql'
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

 
Environment:
CA Performance Management 3.5
Cause:
A password was added for the root MySQL user in 3.5
Resolution:

On CA Performance Management use the password for the root mysqluser and commands as outlined in the documentation.
Additional Information:

CA Performance Mangement 3.5 documentation:

Backup:

https://docops.ca.com/ca-performance-management/3-5/en/administrating/performance-center-administration/back-up-performance-center

Restore:

https://docops.ca.com/ca-performance-management/3-5/en/administrating/performance-center-administration/restore-performance-center