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 do I start mysql?
What happens if null values are involved in expressions?
How to create table with same structure of student table in mysql?
Is mysql a relational database?
How do I install mysql on windows 10?
What is RMS Migrations
Where is the mysql data directory?
What is 'mysqlimport'?
What are the advantages of myisam over innodb?
How to copy data from one server to another using php?
Write a query to stop mysql in unix
How much does mysql cost?
What is row level locking?
How database are managed?
Is sqlite faster than mysql?