No other database can allow any user to connect from any host. : REVOKE « Privilege « MySQL Tutorial






  1. MySQL Tutorial
  2. Privilege
  3. REVOKE
DELETE FROM db
WHERE (db.Host = "%");


DELETE FROM db
WHERE (db.User = "");








27.6.REVOKE
27.6.1.Revoking privileges
27.6.2.To remove UPDATE, INSERT and DELETE privileges
27.6.3.Removing Permissions from a Database
27.6.4.No other database can allow any user to connect from any host.
27.6.5.Removing Permissions from a User