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 the difference between procedure and function in mysql?
What is datadir?
What is mysqlcommand?
Is mysql running ubuntu?
How to rename an existing column in a table?
Write a command with which mysql table can be repaired
What is datatype in mysql?
What is general log in mysql?
Why should I learn mysql?
How to Change a users password from unix shell.
In mysql, what is the default storage engine?
SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?
What is full text indexing in mysql?
Is there a free mysql?
How do I add a column to a table in mysql?