How to change user privileges from 'Y' to 'N' in MySQL Server?

Question

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

Answer 1

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;