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

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

Image for post

I want to create a new user in mysql with syntax:

create user ‘demo’@’localhost’ identified by ‘password’;

But it returns an error:

Your password does not satisfy the current policy requirements.

I have tried many passwords but they don?t work. How can I fix this?

It?s not something safe to do but a simple trick will be something like that :

You can see password validate configuration metrics using the following query in MySQL client:

SHOW VARIABLES LIKE ‘validate_password%’;

or you can set the password policy level lower, for example:

SET GLOBAL validate_password_length = 6;SET GLOBAL validate_password_number_count = 0;

bypassed the error by running the followings:

mysql -h localhost -u root -pmysql>uninstall plugin validate_password;

make sure you reinstall the plugin ?validate_password? if necessary.

if you don?t care what the password policy is. You can set it to LOW by issuing below mysql command:

mysql> SET GLOBAL validate_password_policy=LOW;

Enjoy but again this is not a safe solution !!

67

No Responses

Write a response