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

How do I start mysql?

895


What happens if null values are involved in expressions?

1034


How to create table with same structure of student table in mysql?

951


Is mysql a relational database?

848


How do I install mysql on windows 10?

976


What is RMS Migrations

2396


Where is the mysql data directory?

943


What is 'mysqlimport'?

941


What are the advantages of myisam over innodb?

987


How to copy data from one server to another using php?

1051


Write a query to stop mysql in unix

1055


How much does mysql cost?

925


What is row level locking?

928


How database are managed?

997


Is sqlite faster than mysql?

949