CA Spectrum install fails upgrading mysql error access denied for root user

Document ID : KB000030108
Last Modified Date : 14/02/2018
Show Technical Document Details

ISSUE: Spectrum install fails with the following error seen in the postinst file:

********** Started: Fri Feb 27 11:34:47 2015 **********

running Custom Script Install-Tools/CUS/mysql.cus

 Error(s) occurred. Please see /usr/local/spectrum/Install-Tools/LOGS/9.3.0.3.15_20150227/mysql.log.

Script Install-Tools/CUS/mysql.cus has FAILED

The following error is seen in the mysql.log:

error: 'Access denied for user 'root'@'localhost' (using password: YES)'

 

ROOT CAUSE: The default mysql username and/or password has been changed. The install is expecting the username to be "root" and the password to be "root".

 

RESOLUTION: Set the default mysql username and/or password back to the default root/root and then rerun the install. The mysql username and/or password can be changed after the installation is complete if needed for security reasons but for the install they must be the default values.