How to disable Mysql password validation

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';

That's all…..

Leave a Reply