Give the syntax of GRANT commands?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kamal
GRANT ALL on *.databasename to root identified by 123456
Is This Answer Correct ? | 4 Yes | 0 No |
GRANT ALL ON mydb.mytbl TO 'someuser'@'somehost';
GRANT SELECT, INSERT ON mydb.mytbl TO 'someuser'@'somehost';
Is This Answer Correct ? | 2 Yes | 0 No |
What is the difference between mysql_connect and mysqli_connect?
What you can use regular expression for in mysql?
How to change the database engine in mysql?
What is a text delimiter?
What is acid in mysql?
How can we know the number of days between two given dates using MySQL?
2 Answers Base2 Infotech, Webworks,
What are the advantages/disadvantages of mysql and php?
What is mysql57?
Is mongodb faster than mysql?
What are the differences between MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()?
How do I rename a procedure?
What do you understand by mysql terminal?