GRANT ALL ON mydb.mytbl TO 'someuser'@'somehost'; GRAN

Give the syntax of GRANT commands?

Question Posted / sandeep kumar

Answer Posted / sandeep kumar

GRANT ALL ON mydb.mytbl TO 'someuser'@'somehost';
GRANT SELECT, INSERT ON mydb.mytbl TO 'someuser'@'somehost';

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is tee command in mysql?

910

Do while loop in mysql procedure?

1027

What is triggers?

923

How do I flush privileges in mysql?

949

What is a crosstab query?

910

How do I setup a mysql database?

934

What is select query in mysql?

876

How to write after insert event update trigger on the same table in mysql?

920

What is the difference between now() and current_date()?

938

How to determine the location of the data directory?

917

What is mysql good for?

845

How to shutdown mysql server?

1015

what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL

1343

What is the default password for mysql?

853

What is row level locking in mysql?

940