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 |
Can I use mariadb instead of mysql?
What is mysql server?
Which software is used for mysql?
What are date and time intervals?
Can mysql scale horizontally?
Explain MySQL architecture?
What is clob in mysql
What are the features of Stored Procedures in MYSQL?
Is mysql open source?
How do I change global variables in mysql?
What are the mysql database files stored in system ?
How to make a column bigger and delete unique from table.
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)