The validate_password plugin serves to test passwords and improve security. The plugin exposes a set of system variables that enable you to define password policy.
This article explains the steps to disable Mysql password validation.
Step1: Login to the Mysql as root
Step2: Run the following query
#mysql>uninstall plugin validate_password;
This may not work in the latest versions of MySQL and we can use the following query instead.
#mysql>UNINSTALL COMPONENT 'file://component_validate_password';