Explain GRANT command in MySQL.
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 save in mysql?
What is an index? How can an index be declared in mysql?
What does do in mysql?
What is mysql root?
What is a left join mysql?
Can you tell what are various ways to create an index?
How to return query output in xml format?
Write command to import an mysql file?
how many ways we can get the current date in mysql?
What is clob in mysql
What is default password for mysql?
What is difference between pdo and mysqli?
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)