Mysql monyog privileges

Greetings, We are trying to reduce the number of 'Super" or 'Grant all" privileges in our environment. The following is our monyog mysql login. As far as I can tell it doesn't change any data, just collect stats? I want to know what specific permissions the software needs that requires "SUPER" permission? -- Grants for 'svc_monyog'@'%' GRANT PROCESS, RELOAD, SELECT, SUPER ON *.* TO 'svc_monyog'@'%' IDENTIFIED BY PASSWORD '*6B06015BC68B3E0BE120811B7844DEB5179E6475';
Parents
No Data
Reply
  • Hi, The SUPER privileges are required for the following features,
    1. Replication monitors to fetch the replication information.
    2. MySQL version less than 5.1.24 require SUPER privilege to monitor InnoDB deadlock.
    3. Threads feature require SUPER ignorer to kill running processes.
    You may refer our documentation for the privileges required by Monyog, here. Regards, Sibin
Children
No Data