...

NOTE that the REPLICATION privileges can only be granted at the global level and not specific database on the server.

Using Workbench

 If you are doing so using the MySQL Workbench app you may find that it's easy to get the necessary privileges on the user account by selecting the 

• Administrative Roles

  • ReplicationAdmin

  • BackupAdmin

  • Image Added

For backups

If you want to use this user for dumping the data from the server it will need additional Global privileges.

• SHOW VIEW

• PROCESS (as of MySQL 8.x)

• EVENT

• TRIGGER

• SHOW DATABASES

• RELOAD

• Image Added

Flow User Sample

...