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
How to dump a table to a file with 'mysqldump'?
How do I run mysql from command line?
How to calculate the difference between two time values?
What is text?
What language is mysql written in?
What is processlist in mysql?
What are the differences between a primary key and foreign key?
Which is faster mongodb or mysql?
What are stored procedures and functions?
What data structure does mysql use?
What is delimiter in mysql stored procedure?
How do you know if your mysql server is alive?
Is mysql an oracle product?
How can you move the master database
table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases