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

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

503


How do I run mysql from command line?

460


How to calculate the difference between two time values?

438


What is text?

536


What language is mysql written in?

479






What is processlist in mysql?

472


What are the differences between a primary key and foreign key?

547


Which is faster mongodb or mysql?

435


What are stored procedures and functions?

452


What data structure does mysql use?

557


What is delimiter in mysql stored procedure?

458


How do you know if your mysql server is alive?

477


Is mysql an oracle product?

464


How can you move the master database

1497


table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases

767