Interested to Buy Any Domain ? << Click Here >> for more details...
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 pragma serially_reusable and why is it used?
What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?
Can we store images in mysql database?
how can you test for null values in a database? : Mysql dba
Is postgresql better than mysql?
What is bdb (berkeleydb)?
How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.
How is mysql database stored?
How do you know if your mysql server is alive?
What is a blob datatype?
What is difference between mysql and mysql workbench?
How do I rename a mysql database?
What is view? How can you create and drop view in mysql?
Which is faster innodb or myisam?
What is dblink?
