Error Message

<< Command Prompt> b migrate-db >>
80031 JDBC get connection failed : Access denied for user 'root'@'localhost' (using password: YES)

The Worker Node MySQL is using a password that is different from the Cluster.

Option 1:
Change the Cluster Root MySQL password back to the default value, remove the appliance, then set back the password to the desired value.

Option 2:
a. Start the local MySQL service on the node where migrate-db failed
b. Change the root password of local MySQL server to match the cluster DB root password using the steps below.
  1. Open command prompt and change to the MySQL bin directory (e.g. D:\MySQL\bin)
  2. Enter the command: mysql.exe -uroot -p
  3. This will prompt for the password. Enter the default password.
  4. On the MySQL prompt, execute the following command:
  ►  SET PASSWORD FOR 'root'@'localhost' = PASSWORD('');  
   Example for password 123Password123: 
      SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123Password123');
  5. Execute the following command: 
  ►  FLUSH PRIVILEGES;
c. Close the command window.
d. Stop the EDP services, if running.
e. Run the 'b migrate-db' command again and set the DB to localhost. This will successfully remove the node from the cluster.
f. Start the EDP services