Interested to Buy Any Domain ? << Click Here >> for more details...
Explain GRANT command in MySQL.
- 1 Answers
- 1276 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 mysql queries?
What is SERIAL data type in MySQL?
What are ddl statements in mysql?
how to find 2nd highest salary in random database salary of employer.....
What does mysql flush tables do?
What is the maximum number of records in mysql table?
How many mysql connections can handle?
What is the maximum size of table in mysql?
How to get the number of rows selected or affected by a sql statement?
how to connect a php script with the mysql database?
Restore database (or database table) from backup.
How to create a new table by selecting rows from another table in mysql?
-
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)
