GRANT statement grants privileges to MySQL user accounts.
GRANT also serves to specify other account characteristics such as use of secure connections and limits on access to server resources. To use
GRANT, you must have the GRANT OPTION privilege, and you must have the privileges that you are granting.
Consider the following example:
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON winestore.* TO [email protected] IDENTIFIED BY '
This adds a new user dave and allows him to use only the SQL statements listed in the winestore database. The parameter
winestore.* means all tables within the winestore database.
REVOKE statement enables system administrators to revoke privileges from MySQL accounts. Privileges can be removed with the
REVOKE statement. For example:
REVOKE DROP,CREATE ON winestore.* FROM [email protected]
If the privilege or privileges are to be revoked for all databases in the DBMS, not just a single database,
winestore.* can be replaced with
The following privileges can be used in
ALL PRIVILEGES, FILE, RELOAD, ALTER, INDEX, SELECT, CREATE, INSERT, SHUTDOWN, DELETE, PROCESS, UPDATE, DROP, REFERENCES, USAGE