Guidelines

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.

0 votes
661 views
661 views

I'm trying to grant the PROCESS privilege to a user on my MySQL database:

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

in Sysadmin
by (100)
1 4 18
edit history

Please log in or register to answer this question.

1 Answer

0 votes
 

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:

GRANT PROCESS ON *.* TO bar@localhost;
by (100)
1 4 18
edit history
...