Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to use case expression?
What does mysql workbench do?
What is the purpose of -> in the mysql terminal?
How do I flush privileges in mysql?
What is mysqladmin flush hosts?
How to start mysql server?
What is a text delimiter?
What is mysql in linux?
How to dump a table to a file with 'mysqldump'?
how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.
Can not connect to mysql server 10060?
What is the data type for image?
How do I delete a row in mysql?
In which language it is written?
Why do you think it is advised to not to use guid and character columns as clustered index arrays?
