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

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / shashwat044

pls reply asap

Is This Answer Correct ?    2 Yes 1 No

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

Answer / 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

More MySQL Interview Questions

How to define numeric 9(3) in db2 table without decimal point??

0 Answers  


How many ways we can we find the current date using MySQL?

5 Answers  


How to control the max size of a heap table?

0 Answers  


How do I truncate all tables in mysql?

0 Answers  


What is the difference between unix timestamp and mysql timestamp?

0 Answers  






What is the difference between SQL and SQL Server?

3 Answers   Cognizant, HCL,


What is pdo connection?

0 Answers  


What is the usage of "i-am-a-dummy" flag in mysql?

0 Answers  


How to use in conditions?

0 Answers  


Is mysql relational database?

0 Answers  


How do I check mysql version?

0 Answers  


What is text?

0 Answers  


Categories