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 upload a large file through phpmyadmin in mysql?
What can I do with mysql?
What is int mysql?
What is difference between oracle sql and mysql?
Write a query to create a database and a table?
Is mysql an oracle product?
how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...
Which software is used for mysql?
What is difference between mongodb and mysql?
How to use sum function in where clause in mysql?
How To see all the tables from a database of mysql server.
What is database in php mysql?
How to drop an existing view in mysql?
How do I optimize a selected query in mysql?
How do you login to MySql using Unix shell?
