Connecting With a Mapped Proxy User
To connect to a DB system using a mapped proxy user, first map MySQL proxied users to IAM groups, and then use the mapped proxy user to connect to the DB system.
- Map the MySQL proxied user to an IAM group to obtain the identity and privileges of the MySQL user. See Mapping a MySQL Proxied User to an IAM Group .
- Connect to the DB system with the mapped MySQL proxy user. See Connecting With a Mapped Proxy User.
Mapping a MySQL Proxied User to an IAM Group
Map a MySQL proxied user to an IAM group to grant access to the MySQL Server of the DB system.
Using a Command-Line Client
Use a command-line client such as MySQL Client or MySQL Shell to map MySQL proxied users to IAM groups.
- The OCIDs of the IAM groups and the tenancy in which the groups are defined.
- A running DB system.
- A correctly configured VCN granting command-line access to the DB system either from a compute instance or a local machine.
- A correctly configured command-line client.
- For the required setup to use the
authentication_oci
plugin, see Prerequisites.
You can create and map any number of MySQL proxied users to IAM groups.
Related Topics
Connecting With a Mapped Proxy User
Connect to a DB system with a mapped proxy user. The mapped proxy user assumes the identity and privileges of a MySQL proxied user. Local, federated and provisioned users can use an IAM security token to connect to a DB system. However, only local and provisioned users can use an API key-pair to connect to a DB system.
Using a Command-Line Client
Use a command-line client such as MySQL Client or MySQL Shell to connect to a DB system with a mapped proxy user.
- A running DB system.
- A configuration file. See SDK and CLI configuration file.
- A correctly configured VCN granting command line access to the DB system either from a compute instance or a local machine.
- The user OCID or user ID from identity provider domain of the mapped proxy user.
- For the required setup to use the
authentication_oci
plugin, see Prerequisites.
Related Topics