Interested to Buy Any Domain ? << Click Here >> for more details...
Explain GRANT command in MySQL.
- 1 Answers
- 1283 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 |
Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?
How do I start mysql database?
What is mysqladmin flush hosts?
What does mysql flush privileges do?
What is database engine in mysql?
How to copy data from one server to another using php?
What is 'mysqlshow'?
How do I free up space in mysql?
Consider you have the following three tables which have to be linked together.
What is mysql database used for?
What is clob in mysql
Write a query to display current date and time?
-
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)
