Updated on 2024-09-23 GMT+08:00

Changing the Passwords for Database Users of MRS Cluster Components

This section describes how to regularly change the passwords for database users of cluster components to enhance system O&M security.

Impact on the System

The services need to be restarted for the new password to take effect. The services are unavailable during the restart.

Changing the Passwords for Database Users of MRS Cluster Components (MRS 3.1.0)

This function is only available in MRS 3.1.0. For later versions, refer to Resetting the MRS Component Database User Password.

  1. Log in to FusionInsight Manager and choose Cluster > Services.
  2. Click the name of the service whose database user password is to be reset. On the displayed Dashboard page, click Stop Service.

    In the displayed dialog box, enter the password for the current login user and click OK.

    Once you have confirmed the impact of stopping the service, wait for it to come to a complete stop.

  3. Click the service whose database user password is to be changed, click More, and select Change Database Password. On the displayed page, enter the password for the current login user and click OK.
  4. Enter the old and new passwords as prompted.

    The password must meet the following complexity requirements:

    • The database user password contains 8 to 32 characters.
    • The password contains at least three types of the following: uppercase letters, lowercase letters, numbers, and special characters (~`!@#$%^&*()-+_=\|[{}];",<.>/?).
    • The password cannot be the same as the username or the username spelled backwards.
    • The password cannot be the same as the last 20 historical passwords.

  5. Select I have read the information and understand the impact and click OK.
  6. After the password is changed, choose More > Restart Service. In the displayed dialog box, enter the password for the current login user, click OK, select Restart the upper-layer services, and click OK.

Changing the Passwords for Database Users of MRS Cluster Components (MRS 2.x or Earlier)

  1. On MRS Manager, click Services and click the name of the database user service to be modified.
  2. Determine the component database user whose password is to be changed.

    • To change the password of the DBService database user, go to 3.
    • To change the password for the Hive, Hue, or Loader database user, click Stop Service and go to 3.

  3. Choose More > Change Password.
  4. Enter the old and new passwords as prompted.

    The password complexity requirements are as follows:

    • The password of the DBService database user contains 16 to 32 characters. The password of the Loader, Hive, or Hue database user contains 8 to 32 characters.
    • The password must contain at least three types of the following: uppercase letters, lowercase letters, digits, and special characters ('~!@#$%^&*()-_=+\|[{}];:'",<.>/?).
    • The password cannot be the username or the reverse username.
    • The password cannot be the same as the last 20 historical passwords.

  5. Click OK. The system automatically restarts the corresponding service. When Operation successful is displayed, click Finish.