Permissions for histograms

  • ResolvedModerator Steven Stern (sterndata)

    (@sterndata)


    Volunteer Forum Moderator

    1 year, 2 months ago

    Assuming my db user is “user@localhost”, which tables and permissions does that user need in the “mysql” database? Seems to me it should not be able to see some of the tables (e.g., “user”).

    GRANT <what> on mysql.<which> to 'user'@'localhost';

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Andrew Hutchings

    (@l1nuxjedi)

    1 year, 2 months ago

    There is a MariaDB Jira ticket for this which for some reason I can’t find right now, I’ll update when I can. For the Histograms button to work the user needs SELECT and INSERT access to the mysql.table_stats, mysql.column_stats and mysql.index_stats tables.

    • This reply was modified 1 year, 2 months ago by Andrew Hutchings. Reason: markup typo
    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    1 year, 2 months ago

    Thanks. I’m able to run histograms now.

    Plugin Author Andrew Hutchings

    (@l1nuxjedi)

    1 year, 2 months ago

    No problem, I’ll mark this as resolved for now. But if you have any other issues please let us know.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Permissions for histograms’ is closed to new replies.