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

How many columns can a table have?

852

What is the role of a limit in a mysql query?

947

Which is faster innodb or myisam?

920

How do I setup a mysql database?

921

Do I need to pay for mysql?

849

What is mysql command line?

969

How to create trigger in mysql workbench?

934

Why is mysql used?

880

What is the command used to create a database using php and mysql?

1087

Is mysql still popular?

870

How many rows can mysql hold?

833

How to make a copy values from one column to another in mysql?

972

Explain the difference between delete and truncate.

935

How to rename an existing table in mysql?

965

How do I download mysql on my laptop?

824