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: