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 is ndb in mysql?
What is mysql_connect?
Define REGEXP?
What is difference between mysql and mariadb?
What is trigger in mysql?
What is the maximum connection pool size?
How to shutdown mysql server?
How do I insert an image into mysql workbench?
Explain the storage engines in mysql?
What are queries used for?
How can you move the master database
How do you know if your mysql server is alive?
How to get last inserted id after insert data from a table in mysql?
How to dump a table to a file with 'mysqldump'?
What is the use of mysql_close()?