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 tools available for managing mysql server?

534

Write a query to fetch duplicate records from a table using mysql?

496

Which is faster innodb or myisam?

504

Where is mysql used?

515

Is microsoft sql same as mysql?

499

What is the current root password of mysql?

482

What is the latest mysql?

467

How is data stored in mysql?

488

What is the default port number of mysql?

497

What, if a table has one column defined as TIMESTAMP?

551

How do I restore a database in mysql workbench?

487

Why mysql is so popular?

508

What is the purpose of using ifnull() function?

523

What is mysql procedure?

503

What is triggers and how it can be used in mysql?

522