How to Disable password validation plugin on mySQL

 MySQL 5.7 Version

Step 1: Login to MySQL

#mysql -h localhost -u root -p
mysql> uninstall plugin validate_password;

MySQL 8.0 version (MariaDB)

#mysql -h localhost -u root -p
Enter Password:

mysql>UNINSTALL COMPONENT 'file://component_validate_password';

How to Enable it again

MySQL 5.7

#mysql -h localhost -u root -p
Enter Password:

mysql> install plugin validate_password SONAME 'validate_password.so';

MySQL 8.0 version (MariaDB)

#mysql -h localhost -u root -p
Enter Password:

mysql>INSTALL COMPONENT 'file://component_validate_password';

If you just want to change the policy of password validation plugin:

SET GLOBAL validate_password.policy = 0;   # For LOW
SET GLOBAL validate_password.policy = 1;   # For MEDIUM
SET GLOBAL validate_password.policy = 2;   # For HIGH

There are three levels of password validation policy:

LOW    Length >= 8
MEDIUM Length >= 8, numeric, mixed case, and special characters
STRONG Length >= 8, numeric, mixed case, special characters and dictionary

Reference:

• https://stackoverflow.com/questions/36301100/how-do-i-turn-off-the-mysql-password-validation
• https://techglimpse.com/disable-mysql-password-validation-plugin/