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 |
What is difference between Sql server and MySql database? It may be silly question but i really dont know.
How does mysql store binary data?
What is difference between inner vs self vs cross?
What is delimiter in mysql stored procedure?
What you can use regular expression for in mysql?
Can I use mysql for free?
What is 'mysqlshow'?
What do I do if I forgot my mysql root password?
What is dbms in mysql?
What is the maximum number of records in mysql table?
What are the differences between innodb and myisam engines?
What is the difference between having and where clause in mysql? Explain
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)