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

Tagged: 

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • November 6, 2017 at 9:32 am #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’;

    • November 6, 2017 at 9:38 am #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

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.