Interested to Buy Any Domain ? << Click Here >> for more details...
Explain GRANT command in MySQL.
- 1 Answers
- 1262 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 |
How do I clear a mysql database?
What is regex in mysql?
How to drop an existing table in mysql?
What are the differences between char and varchar data types?
How do I create a new database in mysql?
What are the advantages of mysql?
Is null in mysql?
What is check constraint?
How to enter boolean values in sql statements?
What is text in mysql?
How do I create a database in mysql workbench?
What is the purpose of using timestamp data type?
-
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)
