How can I grant PROCESS privilege to a user?

Question

I have a user called test, and I want to grant process privilege to him.

So far, I have tried:

grant process on *.* to test; 
FLUSH PRIVILEGES;

then, I show all grants for user test by running:

show grants for test@'%';

the result does contain a `PROCESS' line like:

GRANT PROCESS ON *.* TO 'test'@'%' IDENTIFIED BY PASSWORD ...

...

...

But it didn't appear to work for user test.

So, how can I grant PROCESS privilege to a user?

Answer 1

This should do:

GRANT PROCESS, SELECT ON *.* ...