MySQL 8 Administrator???s Guide

No-login pluggable authentication

This is a server-side plugin used to prevent all client connections to any account that uses it. The plugin name is 'mysql_no_login', and it's not a built-in MySQL plugin, so we must use the mysql_no_login.so library. To make it usable, put the library file under the plugin directory first, 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=mysql_no_login.so

2. To register the plugin at runtime, execute the following command:

        INSTALL PLUGIN mysql_no_login SONAME 'mysql_no_login.so';

To uninstall this plugin, execute the following commands:

1. If the plugin was installed on the server startup by using ...