Answer Posted / hrindows@gmail.com
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 |
Post New Answer View All Answers
What does schema mean?
Explain the difference between mysql and mysql interfaces in php?
What is the difference between sql and mysql and oracle?
What is mysqlcommand?
What is bdb (berkeleydb)?
How to show certain selected rows with the value "pcds".
What is the latest version of mysql?
How do I create a mysql database?
How can I see all mysql databases?
Is mysql a programming language?
How to run 'mysql' commands from a batch file?
Does uninstalling mysql delete database?
How do you create a primary key?
How do I download a mysql community server?
What are the differences between char and nchar?