Security plugins
MySQL 8 provides several plugins to implement security. These plugins provide various features related to authentication protocols, password validation, secure storage, and much more. Let's discuss the various types of plugins in detail.
Authentication plugins
The following list of authentication plugins, with their details:
- Native pluggable authentication: To implement native authentication, MySQL 8 uses the
mysql_native_password
plugin. This plugin uses a common name in server and client both the side and inbuilt provided by MySQL 8 for both the server and client program.
- SHA-256 pluggable authentication
To implement SHA-256 hashing MySQL 8 provides two different plugins:
sha256_password
: This plugin is used to implement basic SHA-256 authentication.caching_sha2_password
: This plugin implements SHA-256 authentication along with caching for better performance, and has some additional features as compared to the basic plugin.
This plugin is inbuilt available with MySQL 8 server...