Mega Code Archive

 

Categories / MySQL / User Permission

 

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@'%';