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.
               
 Note
You can authenticate using
You can authenticate using
caching_sha2_password (default),
                mysql_native_password, and sha256_password plugins
            too. See Default Authentication
            Plugins.