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 to connect html form to mysql database using php?
What is row level locking?
Why mysql is so popular?
Restore database (or database table) from backup.
How can you export the table as an xml file in mysql?
How do I edit a trigger in mysql?
How to load a csv file into a table
Can we store pdf files in mysql?
What is mysql and why it is used?
What is “i_am_a_dump” flag in mysql?
How to represent ENUMs and SETs internally?
How can we convert between Unix & MySQL timestamps?
What is a string in mysql?
What does tinyint mean?
Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.