"Your password does not satisfy the current policy requirements" Displayed When Permissions Are Granted or Revoked on DAS

Scenario

The error message "Your password does not satisfy the current policy requirements" is displayed when the root user is used to log in to an instance and run GRANT or REVOKE on Data Admin Service (DAS).

Solution

• MySQL 5.7

  If permissions are granted to a user that does not exist, the message "Your password does not satisfy the current policy requirements" will be displayed.

  In MySQL 5.7, the GRANT statement can automatically create the user when a user does not exist. You are advised to add IDENTIFIED BY to the end of the statement so that the user can be created successfully.

  Check whether a user exists.

  select * from mysql.user where user='<username>';

  GRANT statement:

  grant select on mysql.* to '<username>'@'%' IDENTIFIED BY '<password>';

• MySQL 8.0

  If permissions are granted to a user that does not exist, the message "You are not allowed to create a user with GRANT" will be displayed.

  In MySQL 8.0, you need to create a user using create before granting permissions to it.