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.
Security plugins
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...