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...

Explain GRANT command in MySQL.

Answer Posted / hrindows@gmail.com

When a new MySQL user is created, it requires certain privileges to perform various database operations.
GRANT command grants certain privileges to the user.
For example below statement grants permission to run SELECT and INSERT on TABLE customertable to user username@localhost.
GRANT SELECT, INSERT ON customertable TO ‘username’@’localhost’

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does schema mean?

922


Explain the difference between mysql and mysql interfaces in php?

1065


What is the difference between sql and mysql and oracle?

868


What is mysqlcommand?

972


What is bdb (berkeleydb)?

918


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

918


What is the latest version of mysql?

973


How do I create a mysql database?

899


How can I see all mysql databases?

870


Is mysql a programming language?

868


How to run 'mysql' commands from a batch file?

1028


Does uninstalling mysql delete database?

999


How do you create a primary key?

989


How do I download a mysql community server?

867


What are the differences between char and nchar?

1064