User Permission MySQL

  1. Home
  2. MySQL
  3. User Permission
  4. 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@'%';