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:

MySQL 5.5

update mysql.user set password=password('<new-password-here>') where user like 'root%';

MySQL 5.7

update mysql.user set authentication_string=password('<new-password-here>') where user like 'root%';

MySQL 8.0

flush privileges;
alter user 'root'@'localhost' identified by '<new-password-here>';
alter user 'root'@'127.0.0.1' identified by '<new-password-here>';
alter user 'root'@'::1' identified by '<new-password-here>';

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
```