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
97 views
97 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 10
edit history

Your answer

Preview

Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
By submitting this post you agree to our Terms & Conditions.
To avoid this verification in future, please log in or register.

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 10
edit history
...