Multiserver: Secondary Server - ERROR - Replication failed
Everytime I try to configure a website for my secondary server, i get an error message like this:
ERROR - Replication failed. Error: (sys_group) UPDATE command denied to user 'ispcsrv2'@'192.168.80.81' for table 'server' # SQL: REPLACE INTO sys_group (groupid
,name
,description
,client_id
) VALUES ('2','test','','1')
It seems that the user permissions for the user ispcsrv2 in the MySQL-DB are not sufficient (the global permissions are USAGE) enough. Setting the global permissions on ALL PRIVILEGES would fix the problem, but is a big security risk.
I assume that this is a bug. Unless it is not a bug, what did I do wrong?