MatrixOne Password Management

To protect the security of user passwords, MatrixOne supports password management capabilities:

  • Password complexity strategy: Requires users to set strong passwords to prevent empty or weak passwords.

Password Complexity Strategy

MatrixOne recommends that users set complex passwords to ensure account security.

  • Suggested complexity: uppercase letters, lowercase letters, numbers, and special symbols.
  • Recommended length: no less than 12 characters.

Modify Password Permissions

  • System Administrator (i.e., the root user): Has the highest authority. Can modify the password of the root user itself and the password of Accounts created by the root user.
  • Accounts: Have authority second only to the system administrator. They can modify their own password and the password of ordinary users created by the Account.
  • Other ordinary users: Can only modify their own passwords.

For more information about permission levels, see Privilege Control Types.

Tutorial of Password Changing

Root User Changing Password

Root User Changing their own Password

After starting MatrixOne and successfully logging in with the root, you can use the following command to change the password:

  1. mysql> alter user root identified by '${your password}'

After the change is completed, you can go ahead and exit the current session and log into MatrixOne again for the new password to take effect.

Note

Since the root account is the user with the highest authority by default, please log in with the initial account password and change the password in time.

Root Changing Account’s Password

Refer to ALTER ACCOUNT

Other Users Changing Password

Account Changing their own Password

Refer to ALTER ACCOUNT

Account Changing The Password Of Other Users They Created

Refer to ALTER USER

Ordinary User Changing their own Password

Refer to ALTER USER