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 do I setup mysql?
How can you create and drop view in mysql?
How to return query output in html format?
How do I edit a table in mysql?
What are numeric data types?
Does uninstalling mysql delete database?
How do you login to MySql using Unix shell?
What is mysql enterprise edition?
What is delimiter $$?
What is acid in mysql?
How do I start and stop mysql on windows?
What is mysql and mysqli?
Is blocked because of many connection errors mysql?
What is slow query log in mysql?
What are the disadvantages of mysql?
