install soname "cracklib_password_check";
select * from information_schema.plugins where plugin_name='cracklib_password_check';
PLUGIN_NAME	cracklib_password_check
PLUGIN_VERSION	1.0
PLUGIN_STATUS	ACTIVE
PLUGIN_TYPE	PASSWORD VALIDATION
PLUGIN_TYPE_VERSION	1.0
PLUGIN_LIBRARY	cracklib_password_check.so
PLUGIN_LIBRARY_VERSION	1.14
PLUGIN_AUTHOR	Sergei Golubchik
PLUGIN_DESCRIPTION	Password validation via CrackLib
PLUGIN_LICENSE	GPL
LOAD_OPTION	ON
PLUGIN_MATURITY	Stable
PLUGIN_AUTH_VERSION	1.0
grant select on *.* to foocar identified by 'foocar';
ERROR HY000: Your password does not satisfy the current policy requirements
show warnings;
Level	Code	Message
Warning	1819	cracklib: it is based on your username
Error	1819	Your password does not satisfy the current policy requirements
grant select on *.* to foocar identified by 'racoof';
ERROR HY000: Your password does not satisfy the current policy requirements
show warnings;
Level	Code	Message
Warning	1819	cracklib: it is based on your username
Error	1819	Your password does not satisfy the current policy requirements
grant select on *.* to foo@barbar identified by 'barbar';
ERROR HY000: Your password does not satisfy the current policy requirements
show warnings;
Level	Code	Message
Warning	1819	cracklib: it does not contain enough DIFFERENT characters
Error	1819	Your password does not satisfy the current policy requirements
grant select on *.* to foobar identified by 'qwerty';
ERROR HY000: Your password does not satisfy the current policy requirements
show warnings;
Level	Code	Message
Warning	1819	cracklib: it is based on a dictionary word
Error	1819	Your password does not satisfy the current policy requirements
grant select on *.* to foobar identified by 'q$%^&*rty';
drop user foobar;
#
# MDEV-9851: CREATE USER w/o IDENTIFIED BY clause causes crash
# when using cracklib plugin
#
create user 'newuser'@'localhost';
ERROR HY000: Your password does not satisfy the current policy requirements
uninstall plugin cracklib_password_check;
create user foo1 identified by 'pwd';
drop user foo1;