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

Why do gaps in sequences occur?

1028


1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?

2570


How set mysql root password?

963


How to Change a users password from unix shell.

1172


What is a text delimiter?

996


Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?

1015


How does php communicate with mysql?

952


What is the full form of mysql?

1058


can you tell what are the different set operations available in mysql? : Mysql dba

939


Why do you think it is advised to not to use guid and character columns as clustered index arrays?

1170


How do I stop a query in mysql workbench?

1009


Is mongodb faster than mysql?

992


What are procedures in mysql?

995


What is mysql community edition?

996


Where’s database data actually stored?

1006