Answer Posted / rajan vardawaj
The generic syntax for GRANT is as following GRANT [rights]
on [database] TO [username@hostname] IDENTIFIED BY
[password] Now rights can be: a) ALL privilages b)
Combination of CREATE, DROP, SELECT, INSERT, UPDATE and
DELETE etc. We can grant rights on all databse by usingh *.*
or some specific database by database.* or a specific table
by database.table_name.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What are date and time data types?
What is datadir?
What is data node in mysql cluster?
What do ddl, dml, and dcl stand for?
Explain the architecture models of SQL Server?
How to use count function in mysql?
What is current version of mysql?
How do I run mysql from command line?
Write a command to view mysql database table structure?
How to decrement dates by 1 in mysql?
In which language mysql has been written?
write a query to mysql in safe mode and to change the root password
What is the full form of mysql?
What are all the Common SQL Function?
Is mysql query case sensitive?
