Creating an Applier User On a Target DB System
The applier user is a user account that resides in the replica server and supplies a security context for a MySQL replication channel. The account must have the REPLICATION_APPLIER
privilege, plus all required privileges to execute the transactions replicated on the channel.
HeatWave inbound replication requires an applier user which defaults to the administrator account of the DB system. If you need a more restrictive set of privileges for the applier user, you can create a separate user account, grant all required privileges to the account, and specify the account as the applier user when you create the channel.
Related Topics
Using a Command-Line Client
Use a command-line client such as MySQL Shell or MySQL Client to create an applier user with required privileges on the target DB system.
- MySQL Shell 8.0.27 or higher, or a MySQL Client.
The applier user is created and granted with the required privileges.