Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Mysql monyog privileges

forums forums Monyog Using Monyog Mysql monyog privileges

This topic contains 1 reply, has 2 voices, and was last updated by  Sibin A S 1 week, 6 days ago.

  • Author
    Posts
  • #36038

    Joe Gibbs (Hurley)
    Participant

    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’;

  • #36043

    Sibin A S
    Moderator

    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

You must be logged in to reply to this topic.