Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Give the syntax of GRANT commands?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the technical features of MySQL?

964


What is mysql in dbms?

956


What is trigger in mysql?

884


Is mysqli faster than mysql?

875


What is slow query log in mysql?

1044


What are the functions used to encrypt and decrypt the data present in mysql?

1029


What is the maximum connection pool size?

912


How to control the max size of a heap table?

941


How to show certain selected rows with the value "pcds".

897


What is the default port of mysql server?

983


Can I use mariadb instead of mysql?

872


Can mongodb replace mysql?

896


How to enter Characters as HEX Numbers?

966


what is the procedure to configure the application of mysql?

977


What is the latest mysql version?

940