[SOLVED] Remove MySQL/MariaDB "Grant" Permission through command line

schnappi · 06-21-2017, 09:27 PM

Know how to remove the "grant" permissions (ability to edit permissions of other users on database) in phpmyadmin. How can one remove grant permissions through the command line?

Is this the way to do it?

Code:

REVOKE "grant option" ON database.* FROM user@localhost;

scasey · 06-21-2017, 11:36 PM

Quote:

Originally Posted by schnappi

Know how to remove the "grant" permissions (ability to edit permissions of other users on database) in phpmyadmin. How can one remove grant permissions through the command line?

Is this the way to do it?

Code:

REVOKE "grant option" ON database.* FROM user@localhost;

phpmyadmin echos the command when you do it there... I see:

Code:

REVOKE GRANT OPTION ON * . * FROM 'testj'@'localhost';

Habitual · 06-22-2017, 05:52 AM

I have to go to https://dev.mysql.com/doc/refman/5.7/en/revoke.html every time.