I created two azure database for mysql servers to simulate the master-replica architecture.
On replica server, I ran the below command and got the error Command:-
CHANGE MASTER TO MASTER_HOST='<server-name>.database.azure.com', MASTER_USER='<user_name>', MASTER_PASSWORD='<password>',MASTER_LOG_FILE='<file_name>', MASTER_LOG_POS=<position>
Error:-
ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER or REPLICATION_SLAVE_ADMIN privilege(s) for this operation
so after that I tried running this command, then got the following error
GRANT REPLICATION_SLAVE_ADMIN ON *.* TO 'vanshmittal_official'@'%';
Error:-
ERROR 1227 (42000): Access denied; you need (at least one of) the GRANT OPTION privilege(s) for this operation
I have logged in as vanshmittal_official, here are the privelege I have
show grants for 'vanshmittal_official'@'%';
Can anyone please help, provide suggestions of what wrong I am doing?
Also is it possible for me to get super privelege as a user?
Thanks!