Configure MySQL Settings

You may want to modify the MySQL settings for security or management purposes.

To begin, open a Command Prompt (Start menu > All Programs > Accessories > Command Prompt) and execute the following commands:

Change the Database root Login Password

MySQL database's root account's password is set during the setup process. For security reasons, update the password. Use the following command to change the password. Enter the new and old password when prompted:

> asctl mysql:set_root_password

Change the MySQL Port

By default, Console's MySQL uses TCP port 4406. Use the following command to change it.

> asctl mysql:port 1234

If the MySQL's port number is changed, you will need to provide the updated Console settings to all the nodes, and reflect the new settings in all the nodes' aspera.conf files.