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|
Is mysql and sql are same?
How do you restart mysql?
What is trigger in mysql?
What does blob mean in mysql?
How would you get the current date in mysql?
How to convert numeric values to character strings?
What is msql?
What is federated tables in mysql?
What is mysql community server?
What is mysqli procedural?
What is sql vs mysql?
what is the difference between gui testing and database testing? : Mysql dba