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
Which command is used to view the content of the table in mysql?
How to dump one database for backup.
How to use mysqldump to create a copy of the database?
What are mysql queries?
How many columns can a table have?
What is row level locking in access?
What is a trigger in mysql?
How can I remotely connect to mysql database?
How to Join tables on common columns.
Write a query to stop mysql in unix
What is the function of myisamchk?
How do I rename a procedure?
what is cte? : Mysql dba
What language is used in mysql?
What is indexing in mysql?
