Give the syntax of GRANT commands?

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

More MySQL Interview Questions

What is the difference between mysql_connect and mysqli_connect?

0 Answers  


What you can use regular expression for in mysql?

0 Answers  


How to change the database engine in mysql?

0 Answers  


What is a text delimiter?

0 Answers  


What is acid in mysql?

0 Answers  






How can we know the number of days between two given dates using MySQL?

2 Answers   Base2 Infotech, Webworks,


What are the advantages/disadvantages of mysql and php?

0 Answers  


What is mysql57?

0 Answers  


Is mongodb faster than mysql?

0 Answers  


What are the differences between MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()?

2 Answers  


How do I rename a procedure?

0 Answers  


What do you understand by mysql terminal?

0 Answers  


Categories