Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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

SHOW GRANTS;

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

share|improve this answer

Your Answer

 
discard

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.