Privilege required to reset non-root users password

{question}

What are the privileges required to reset non-root user's passwords?

{question}

{answer}

The answer is the particular user would require SUPER privilege for changing the passwords of other users. This requirement relates to automating password rotation with a password manager, so the user who will be used as a password manager should have SUPER privilege to handle password rotation for all users.

Step 1: Creating a User with SUPER privilege or adding SUPER privilege to an existing user:

singlestore> GRANT SUPER ON *.* TO 'password_manager'@'%'; 
Query OK, 0 rows affected (0.00 sec)

Step 2: Connecting to MA with that user:

singlestore -h 198.165.1.1 -u password_manager -P 3306 -p

Step 3: Using the below command, we can reset the password of other users:

singlestore> SET PASSWORD FOR 'user_1'@'%' = PASSWORD('securePass'); 
Query OK, 0 rows affected (0.00 sec)

Click here to learn more about SET PASSWORD.

{answer}