write a c++ program to add a user to mysql.the user should be
permitted to only "insert" into the given database
Answer Posted / riyas_isno
CREATE PROCEDURE createUser (OUT param1 INT)
BEGIN
CREATE USER 'sonu'@'localhost' IDENTIFIED BY 'riyaz';
GRANT insert ON db1.* TO 'riyaz'@'localhost';
END
hope this will be the answer ....try it......
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is msql?
What is a storage engine? What are the differences between innodb and myisam engines?
What is the datatype of image?
What is dblink?
Is mysql server free?
Where is the mysql database stored?
Where is the mysql config file?
Which is better mysql or microsoft sql?
What is the maximum size of table in mysql?
How do I find users in mysql?
Which is faster mongodb or mysql?
What is mysqli_select_db?
How do I edit a table in mysql workbench?
What is append query?
What are the different tables present in MySQL?