MySQL Forums
Forum List  »  Replication

Re: Multiple replication users
Posted by: Rick James
Date: May 24, 2016 10:02AM

No.

The replication "user" is internal to MySQL, and there is no reason I can think of for having two users. Would you explain why you want two users?

The replication user needs only
GRANT REPLICATION SLAVE ON *.* TO ...
"REPLICATION SLAVE" is a special privilege that does not overlap with normal "users". It allows access to all databases. No other "users" should be granted REPLICATION SLAVE.

To do SHOW SLAVE STATUS, you a user needs REPLICATION CLIENT, which I think is part of ALL PRIVILEGES.

Options: ReplyQuote


Subject
Views
Written By
Posted
1330
May 18, 2016 01:16PM
Re: Multiple replication users
827
May 24, 2016 10:02AM
797
May 24, 2016 01:29PM
789
May 27, 2016 11:16PM
668
May 30, 2016 08:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.