Explain GRANT command in MySQL.
- 1 Answers
- 498 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 to connect a php script with the mysql database?
What is mysql data directory?
How can we change the name and data type of a column of a table?
What is difference between mysql and mysql workbench?
What is the difference between procedure and function in mysql?
How to check if a record exists in a mysql database php?
How to get nth highest salary from table in a mysql?
What are some good ideas regarding user security in MySQL?
How do I select a database in mysql workbench?
What are date and time data types in mysql?
Is mysql case-sensitive?
Can we store images in mysql database?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
