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


Please Help Members By Posting Answers For Below Questions

What is the difference between procedure and function in mysql?

710


What is datadir?

651


What is mysqlcommand?

688


Is mysql running ubuntu?

676


How to rename an existing column in a table?

748


Write a command with which mysql table can be repaired

734


What is datatype in mysql?

670


What is general log in mysql?

671


Why should I learn mysql?

693


How to Change a users password from unix shell.

771


In mysql, what is the default storage engine?

699


SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?

795


What is full text indexing in mysql?

712


Is there a free mysql?

674


How do I add a column to a table in mysql?

669