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 !!