The loading of the plugins varies with their types and characteristics. To get a clearer picture of this, let's go though the following:
- Built-in plugins: The server knows about the built-in plugins and loads them automatically, on startup. The user is allowed to change the state of plugins by any of their activation statuses, which will be discussed in the following section.
- Plugins registered in the mysql.plugin system table: On startup MySQL 8 server will load all the plugins which are registered in the mysql.plugin table. If the server is started with the --skip-grant-tables option, the server will not load the plugins listed there.
- Plugins named with command-line options: MySQL 8 provides the --plugin-load