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 is a storage engine?
Which is better mysql or mssql?
What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?
What is difference between inner vs self vs cross?
What is the use of mysqli_query?
How do I start and stop mysql on windows?
What is join in mysql? What are the different types of join?
What is mysqli_free_result?
What is a join in mysql?
How to escape special characters in sql statements?
i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?
How to use count function in mysql?
What are the difference between and myisam and innodb?
What are procedures in mysql?
how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.
