Change the Database Root User Password

To change the platformAdmin.databaseRootPassword, follow these steps:

  1. Stop the Enterprise Console by running the following command in <EC_home>/Platform/platform-admin/bin:
    bin/platform-admin.sh stop-platform-admin
  2. Run the following command in <EC_home>/Platform/mysql/bin:
    bin/mysqld --defaults-file="/<EC_home>/Platform/mysql/db.cnf" --skip-grant-tables

    Replace <EC_home> before running the command.

  3. Open a new command prompt window.
  4. Connect to the database without using a password by running the following command in <EC_home>/Platform/mysql/bin:
    bin/mysql -u root -h 127.0.0.1 -P 3377 --protocol=TCP
  5. Execute the following queries:
    update mysql.user set authentication_string=password('<new_password_here>') where user like 'root%';
flush privileges;
quit;

    Replace <new_password_here> before executing the queries.

  6. Quit the command prompt.
  7. Stop the Enterprise Console Database by running the following command in <EC_home>/Platform/platform-admin/bin:
    bin/platform-admim.sh stop-platform-admin
    Warning: This is to stop the MySQL DB and start it without using the --skip-grant-tables option that is in the next step.
  8. Start the Enterprise Console by running the following command in <EC_home>/Platform/platform-admin/bin:
    bin/platform-admin.sh start-platform-admin
  9. Verify the login by running the following command in <EC_home>/Platform/mysql/bin:
    bin/mysql -u root -p -P 3377 -h 127.0.0.1