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 is ndb in mysql?

906


What is mysql_connect?

901


Define REGEXP?

1035


What is difference between mysql and mariadb?

1029


What is trigger in mysql?

875


What is the maximum connection pool size?

904


How to shutdown mysql server?

1004


How do I insert an image into mysql workbench?

897


Explain the storage engines in mysql?

950


What are queries used for?

892


How can you move the master database

1971


How do you know if your mysql server is alive?

989


How to get last inserted id after insert data from a table in mysql?

926


How to dump a table to a file with 'mysqldump'?

954


What is the use of mysql_close()?

925