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 'riyaz'@'localhost' IDENTIFIED BY 'riyaz';
GRANT insert ON db1.* TO 'riyaz'@'localhost';
END

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is mysql procedure?

511


State the differences between mongodb and mysql.

525


Is mysql free software?

501


How many ways to get the current time?

510


What is msql?

535






What is procedures in mysql?

512


What is the difference between unix timestamp and mysql timestamp?

524


What is mysql root?

492


How to do login in mysql with unix shell.

546


How do I find the database name in mysql?

517


What sql does mysql use?

493


Explain the storage engines in mysql?

530


Which mysql function is used to concatenate string?

780


What causes mysql too many connections?

482


How to use rank function in mysql?

482