Does replication needs root access?

Help
1

Does replication always need root access or the login can just needs ‘CREATE DATABASE’ and ‘REPLICATION’ privileges.

Thanks,
Sid.

2

You should be able to do what you need (start up replication) with just CREATE DATABASE permission. And of course you will need the credentials to log into the source database from which you are replicating the data.

1 Like
3

Thank you Hanson. Do I need to be root or I can use just another login with specific memsql permission? That is what I have done before in the past with other database vendors using a dedicated replication login.

Sid.

4

No, you don’t need to be root. The user you log in as needs to have CREATE DATABASE permission. That can be granted to you by another user.

5

Thanks for the information.