Answer Posted / rajan vardawaj
The generic syntax for revoke is as following REVOKE
[rights] on [database] FROM [username@hostname] 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 ? | 7 Yes | 0 No |
Post New Answer View All Answers
How internally data stores in MyISAM and INNODB table types?
What is dirty read and phantom read?
State the differences between mongodb and mysql.
What can you do with mysql?
How can I see connections in mysql?
How to check if value already exists in mysql database in php?
How do I start mysql?
What is a text delimiter?
In which format data is stored in mysql database?
explain GROUPBY & HAVING clause with examples.
How do I backup mysql database on linux?
What are the two types of queries?
What are the functions of commit and rollback statements?
How to dump a table to a file with 'mysqldump'?
What is field in mysql?