Basic PHP Programming Question:
Download Questions PDF

Give the syntax of GRANT commands?

Answer:

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 usingh *.* or some specific database by database.* or a specific table by database.table_name.

Download PHP Interview Questions And Answers PDF

Previous QuestionNext Question
How many ways we can we find the current date using MySQL?Give the syntax of REVOKE commands?