This site is for tech Q&A. Please keep your posts focused on the subject at hand.
Ask one question at a time. Don't conflate multiple problems into a single question.
Make sure to include all relevant information in your posts. Try to avoid linking to external sites.
Links to documentation are fine, but in addition you should also quote the relevant parts in your posts.
I'm trying to grant the PROCESS privilege to a user on my MySQL database:
PROCESS
GRANT PROCESS ON `foo`.* TO bar@localhost;
However, I'm getting the following error:
ERROR 1221 (HY000) at line 1: Incorrect usage of DB GRANT and GLOBAL PRIVILEGES
As the error message indicates, the PROCESS privilege is a global privilege, so it can't be assigned on a database level (foo in your example). This should work:
foo
GRANT PROCESS ON *.* TO bar@localhost;
