My Oracle Support Banner

Oracle Big Data Appliance 4.2 to 4.5 Upgrade of a CDH Cluster Fails on Step 1with " ERROR 1045 (28000): Access denied for user 'root'" (Doc ID 2151255.1)

Last updated on MARCH 09, 2019

Applies to:

Big Data Appliance Integrated Software - Version 4.2.0 and later
Linux x86-64

Symptoms

Step 1 of Mammoth upgrade verifies the passwords for the 'root' MySQL user on both the MySQL Master and MySQL Slave databases for all cluster nodes. 

The symptom here is that entering the correct MySQL 'root' password causes a Step 1 to fail with: "ERROR 1045 (28000): Access denied for user 'root'".

This can happen on any BDA version.

Step 1 failure output when the correct password is entered looks like:

WARNING: The password for the MySQL root user is missing from the parameters file and is required for the installation.
Enter password:
Enter password again:
INFO: Executing verifyMySQLPasswd.sh on nodes /opt/oracle/BDAMammoth/bdaconfig/tmp/all_nodes #Step 1#
ERROR: Error code 1 when executing verifyMySQLPasswd.sh on host bdanode07 #Step 1#
ERROR: Error is : ERROR 1045 (28000): Access denied for user 'root'@'bdanode07.example.com' (using password: YES) #Step 1#
ERROR: Error code 1 when executing verifyMySQLPasswd.sh on host bdanode8 #Step 1#
ERROR: Error is : ERROR 1045 (28000): Access denied for user 'root'@'bdanode08.example.com' (using password: YES) #Step 1#
ERROR: Error code 1 when executing verifyMySQLPasswd.sh on host bdanode09 #Step 1#
ERROR: Error is : ERROR 1045 (28000): Access denied for user 'root'@'bdanode09.example.com' (using password: YES) #Step 1#
ERROR: Error code 1 when executing verifyMySQLPasswd.sh on host bdanode10 #Step 1#
ERROR: Error is : ERROR 1045 (28000): Access denied for user 'root'@'bdanode10.example.com' (using password: YES) #Step 1#
ERROR: Errors executing verifyMySQLPasswd.sh. Continuing anyway. #Step 1#
WARNING: Incorrect password. Do you wish to try again? (yes/no):
yes
Enter password:
Enter password again:
INFO: Executing verifyMySQLPasswd.sh on nodes /opt/oracle/BDAMammoth/bdaconfig/tmp/all_nodes #Step 1#
ERROR: Error code 1 when executing verifyMySQLPasswd.sh on host bdanode07 #Step 1#
ERROR: Error is : ERROR 1045 (28000): Access denied for user 'root'@'bdanode07.example.com' (using password: YES) #Step 1#
ERROR: Error code 1 when executing verifyMySQLPasswd.sh on host bdanode08 #Step 1#
ERROR: Error is : ERROR 1045 (28000): Access denied for user 'root'@'bdanode08.example.com' (using password: YES) #Step 1#
ERROR: Error code 1 when executing verifyMySQLPasswd.sh on host bdanode09 #Step 1#
ERROR: Error is : ERROR 1045 (28000): Access denied for user 'root'@'bdanode09.example.com' (using password: YES) #Step 1#
ERROR: Error code 1 when executing verifyMySQLPasswd.sh on host bdanode10 #Step 1#
ERROR: Error is : ERROR 1045 (28000): Access denied for user 'root'@'bdanode10.example.com' (using password: YES) #Step 1#
ERROR: Errors executing verifyMySQLPasswd.sh. Continuing anyway. #Step 1#
WARNING: Incorrect password. Do you wish to try again? (yes/no):

Other symptoms:

The cluster may have been previously extended. However the same symptoms can be present if a cluster expansion did not happen.

In the case of a previous cluster expansion the MySQL 'root' password may be present for all hosts in the MySQL primary database, but the MySQL 'root' password may be missing for the nodes expanded into the cluster.  For example:

The MySQL Master database shows the MySQL 'root' password for all cluster nodes:

On BDA 4.8 and higher with MySQL 5.7:

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.