E
x
c
e
l
P
T
P

Give the syntax of GRANT commands?

March 4, 2014

The generic syntax for GRANT is as following:
GRANT [rights] on [database] TO [username@hostname] IDENTIFIED BY [password]

Now rights can be:
a) ALL privilages

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.