Explain GRANT command in MySQL.
- 1 Answers
- 799 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 is the difference between unix timestamp and mysql timestamp?
Is mysql is a programming language?
What is ACID?
How do you say mysql?
Can mongodb replace mysql?
How many sql ddl commands are supported by 'mysql'?
What is view in mysql?
What is dbms in mysql?
How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.
How to calculate the difference between two dates?
How can you make a database as your current database?
Is mysql a good database?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
