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
What are the technical features of MySQL?
What is mysql in dbms?
What is trigger in mysql?
Is mysqli faster than mysql?
What is slow query log in mysql?
What are the functions used to encrypt and decrypt the data present in mysql?
What is the maximum connection pool size?
How to control the max size of a heap table?
How to show certain selected rows with the value "pcds".
What is the default port of mysql server?
Can I use mariadb instead of mysql?
Can mongodb replace mysql?
How to enter Characters as HEX Numbers?
what is the procedure to configure the application of mysql?
What is the latest mysql version?