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
Why do gaps in sequences occur?
1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?
How set mysql root password?
How to Change a users password from unix shell.
What is a text delimiter?
Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?
How does php communicate with mysql?
What is the full form of mysql?
can you tell what are the different set operations available in mysql? : Mysql dba
Why do you think it is advised to not to use guid and character columns as clustered index arrays?
How do I stop a query in mysql workbench?
Is mongodb faster than mysql?
What are procedures in mysql?
What is mysql community edition?
Where’s database data actually stored?