Authenticating Using authentication_oci Plugin

Once you have connected to a DB system, use authentication plugins such as authentication_oci to authenticate users. MySQL authentication_oci plugin enables you to map MySQL users to existing local, federated, or provisioned users. This enables you to log in to the MySQL Server of the DB system from the command-line, or one of the MySQL Connectors (version 8.0.27 or higher), using an API key-pair or IAM security token for authentication.


You can authenticate using caching_sha2_password (default), mysql_native_password, and sha256_password plugins too. See Default Authentication Plugins.