a1exlism
7/2/2016 - 11:43 AM

MySQL5.6+'s password plugin

SHOW VARIABLES LIKE 'validate_password%';  ==> current settings
SET GLOBAL validate_password_policy = 'LOW';
SET GLOBAL validate_password_length = 5;   ==> global change to this plugin

SET password=PASSWORD("your passwd");