Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 0 down vote accepted

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


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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.