Re: validate_password plugin stick with MEDIUM policy after mysql reboot on UBUNTU

[Georgi Kodinov]

In order to supply values for system variables defined in a plugin one of the two things should happen:
1. the plugin should be present when the configuration file is read. This is ensured either through loading the plugin via the command line (as you did above) or via installing the plugin via INSTALL PLUGIN SQL command.
2. You specify the --loose prefix to your variables (e.g. --loose-validate_password_policy=LOW). This makes the server to tolerate the unknown option value and not refuse to start in a hope that a later INSTALL PLUGIN command will add the plugin that will read the value supplied.

I would personally suggest that you use #1 (as you did). This prevents you from accumulating options that are e.g. spelled wrong etc.

Also FYI, SET GLOBAL is a run-time operation only. It doesn't persist the value in any shape or form. The moment your server is restarted the SET GLOBAL value is gone.

In 8.0 we have added something called SET PERSIST that does what SET GLOBAL does, but also persists the value.

I suggest you study it (https://dev.mysql.com/doc/refman/8.0/en/persisted-system-variables.html) and consider upgrading to mysql 8.0 to take advantage of it if you like it.

Georgi "Joro" Kodinov
MySQL SrvGen team lead
Plovdiv, Bulgaria