Explain GRANT command in MySQL.

Question Posted / hrindows@gmail.com

1 Answers
1340 Views
I also Faced
E-Mail Answers

Explain GRANT command in MySQL...

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

More MySQL Interview Questions

SQL: 1. Write a queryto retrieve the author who was published a book at the youngest age? 2. write a query to retrieve the no. of books published a each year in various languages? 3. write a query to retrieve no. of books published by them only those authors who have published more than 1 book? 4. write a query to retrieve who has not published any books during the year 2006? 5. write a query to retrieve the authors who has published any books during the birth date write this query in 2 ways 1)joins 2)sub query 6. write a query to retrieve all the books which was published during jan 2007 & title containing India or published in the language hindi? 1. table name is liberary managemnt and two column is there one is authors and another one is books . 2.four fields will comes under authours like nationality, birthdate ,first-language,second-language 3.four fields will comes under books like authour,title ,language,publish date to write query using this details

4 Answers Covansys,

how we can use more then one primary key in Single Table

9 Answers Systematix,

Why do we need mysql?

0 Answers

What is the difference between mysql and sql?

0 Answers

What are views in mysql?

0 Answers

how fastest access of data can be done from database ?

3 Answers

1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?