Revoke ALL privileges from the user second, delete the user, and then verify the removal. : REVOKE « User Permission « SQL / MySQL






  1. SQL / MySQL
  2. User Permission
  3. REVOKE

Revoke ALL privileges from the user second, delete the user, and then verify the removal.

   

REVOKE ALL ON *.* FROM second@`%`;

DELETE FROM mysql.user
WHERE USER="second"
AND HOST= "%";

FLUSH PRIVILEGES;

SHOW GRANTS FOR second@'%';








Related examples in the same category

1.REVOKE statement syntax
2.How the REVOKE statement works
3.The REVOKE Statement
4.Revoke select privilege
5.Revoke references privilege
6.Revoke insert and select