Change the Database Root User Password

To change the platformAdmin.databaseRootPassword, follow these steps:

Stop the Enterprise Console by running the following command in <EC_home>/Platform/platform-admin/bin:
```
bin/platform-admin.sh stop-platform-admin
```
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.
Open a new command prompt window.
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
```

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.

Quit the command prompt.
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.
Start the Enterprise Console by running the following command in <EC_home>/Platform/platform-admin/bin:
```
bin/platform-admin.sh start-platform-admin
```
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
```

Documentation