ERROR1819 (HY000): Your password does not satisfy the current

​

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

​

If the password is set to validate_password_policy, the password is set to validate_password_policy.

​

If you want to view the complete initial password rules for MySQL, run the following command:

SHOW VARIABLES LIKE ‘validate_password%’;

​

The password length is determined by validate_password_length. Validate_password_policy determines the password verification policy. The default level is MEDIUM.

set global validate_password_policy=0;

​

MySQL > grant user privileges to a database

Step 1: Log in to mysql as user root

Step 2: Add user permissions, passenger_Flow_Analysis (database name), pFA (user name), pFA123qwe (password)

grant all privileges on passenger_flow_analysis.* to ‘pfa’@’%’ identified by ‘pfa123qwe’ with grant option;

Step 3: Refresh permissions

flush privileges;

​

\

​