CREATE PROCEDURE createUser (OUT param1 INT) BEGIN CREATE USER 'sonu

write a c++ program to add a user to mysql.the user should be
permitted to only "insert" into the given database

Question Posted / riyas_isno

3 Answers
7024 Views
Infosys, Webyog, I also Faced
E-Mail Answers

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

Is mysql from oracle?

969

Write a query to display current date and time?

924

What is datatype in mysql?

950

Can we join 3 tables in mysql?

957

What is difference between Sql server and MySql database? It may be silly question but i really dont know.

2119

What does do in mysql?

877

What is the storage engine for mysql?

960

What is the difference between mysql_fetch_assoc and mysql_fetch_array?

1070

Why do we use group by and order by function in mysql?

919

What is 'mysqlimport'?

935

What is a mysql view?

840

What is the innodb in mysql?

1044

How to calculate the difference between two dates?

1061

What tools available for managing mysql server?

1025

How do I declare a variable in mysql?

952