MySQL 8 Administrator???s Guide

Install password validation plugin

We must use the validate_password.so library with this plugin. To make it usable, put the library file under the plugin directory first, and then perform either of these steps:

1. Load the plugin on server startup by adding the --plugin-load-add parameter in the my.cnf file:

         [mysqld]         plugin-load-add=validate_password.so

2. Register the plugin at runtime by executing the following command:

        INSTALL PLUGIN validate_password SONAME 'validate_password.so';