Give the syntax of GRANT commands?

Question Posted / rajan vardawaj

3 Answers
5035 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Give the syntax of GRANT commands?..

Answer / rajan vardawaj

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.

Is This Answer Correct ?

8 Yes

0 No

Give the syntax of GRANT commands?..

Answer / kamal

GRANT ALL on *.databasename to root identified by 123456

Is This Answer Correct ?

4 Yes

0 No

Give the syntax of GRANT commands?..

Answer / sandeep kumar

GRANT ALL ON mydb.mytbl TO 'someuser'@'somehost';
GRANT SELECT, INSERT ON mydb.mytbl TO 'someuser'@'somehost';

Is This Answer Correct ?

2 Yes

0 No

Post New Answer