MySQL ReadOnly user cannot see slow query log

Question

I have the MySQL slow query log turned on. For my main user account I can run this query and see results:

select * from mysql.slow_log limit 1;

I also have a "readonly" user account. This account has SELECT permission for every schema. When I log in as this user and run the above query, I get 0 results. No error or warning appears, it just looks like the log is empty.

Do I need to give my "readonly" user another permission or something? Any ideas?

Answer 1

You will need someone with all MySQL Privileges to run this command:

GRANT SELECT on mysql.slow_log TO 'username'@'host';

To see your username and host run

SHOW GRANTS;

and ask MySQL DBA to grants the above permission on mysql.slow_log