Interested to Buy Any Domain ? << Click Here >> for more details...
Explain GRANT command in MySQL.
- 1 Answers
- 1192 Views
- I also Faced
- E-Mail Answers
When a new MySQL user is created, it requires certain privileges to perform various database operations.
GRANT command grants certain privileges to the user.
For example below statement grants permission to run SELECT and INSERT on TABLE customertable to user username@localhost.
GRANT SELECT, INSERT ON customertable TO ‘username’@’localhost’
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the purposes of using enum and set data types?
Is mysql a backend?
What sql does mysql use?
Can foreign key have duplicate values?
How to insert dynamic values in mysql using php?
State the differences between mongodb and mysql.
What is the difference between database and table?
How to display top 10 rows in mysql?
How do you rename a table in mysql?
How set mysql root password?
How do I delete a table in mysql workbench?
How can you retrieve a portion of any column value by using a select query?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
