Interested to Buy Any Domain ? << Click Here >> for more details...
Explain GRANT command in MySQL.
- 1 Answers
- 1193 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 truncate all tables in mysql?
How to create a new view in mysql?
How do I restore a mysql database dump file in linux?
How to check server status with 'mysqladmin'?
suppose server is running Suddenly down . what can you do? but i want do not down the server?
How can you change the password of a mysql user?
What is mysql uuid?
What is a heap table?
What, if a table has one column defined as TIMESTAMP?
How to create table show example
What is difference between statement and preparedstatement?
What is row level locking?
-
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)
