The generic syntax for grant is as following
i) GRANT [rights] on [database/s] TO [username@hostname] IDENTIFIED BY [password] now rights can be
a) All privileges
b) combination of create, drop, select, insert, update and delete etc.We can grant rights on all databse by using *.* or some specific database by database.* or a specific table by database.table_name username@hotsname can be either username@localhost, username@hostname
and username@% where hostname is any valid hostname and % represents any name, the *.*
any condition password is simply the password of userThe generic syntax for revoke is as following
ii) REVOKE [rights] on [database/s] FROM [username@hostname] now rights can be as explained above
a) All privileges
b) combination of create, drop, select, insert, update and delete etc.
username@hotsname can be either username@localhost, username@hostname and username@% where hostname is any valid hostname and % represents any name, the *.* any condition