I want to change a privilege to my glpiuser from 'N' to 'Y'. In MySQL server, what is the command to do this task? Here's the image that display my users. I'm using Ubuntu 20.04.1

  • 2
    Please don't post images of text; images are often hard to read (or unreadable for people with visual impairments), they can't be used by search engines, and text can't be copied from them. Edit your question and replace the link to the image with text. Regarding the question, to grant privileges, use the GRANT statement. – berndbausch Apr 18 at 2:26

The GRANT statement enables system administrators to grant privileges and roles, which can be granted to user accounts and roles.

The REVOKE statement revokes one or more privileges from a user account.

So, something like this will most likely do what you need:

REVOKE All ON <DB> FROM user@source;
  • REVOKE is more clumsy than implied here. – Rick James Apr 19 at 21:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy