write a c++ program to add a user to mysql.the user should be permitted to onl

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

Question Posted / shashwat044

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

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 do I view data in mysql workbench?

0 Answers

What is the use of mysqli_connect in php?

0 Answers

How to get a list of all tables in a database?

0 Answers

Describe mysql transaction properties.

0 Answers

please give me the answer for this: query which generates the second highest integer in the table?

8 Answers

Is mysql written in c?

0 Answers

What is the size of mysql database?

0 Answers

How to use case expression?

0 Answers

What are programming functions?

0 Answers

Please suggest me any course and institute which provide training on the below skills. • Knowledge of data extraction concepts and tools • QMF (query management facility)queries • Experience and expertise in QMF queries • Excellent ability to write, read, and interpret QMF queries against the Source Data Warehouse base level (daily and monthly) and month-end affinity comp tables • RDBMS & ER • Knowledge of Relational Databases (RDBMS) and Entity Relationship (ER) Diagrams • SOURCE Data Warehouse • Experience and expertise in Source Data Warehouse or data warehouses on the mainframe. • MS SQL Server • Experience in MS SQL Server • Excellent skill in writing/interpreting SQL queries and running Data Transformation Services (DTS) or open query packages. • Knowledge of writing/interpreting Visual Basic code.

1 Answers

How do I create a stored procedure in mysql?

0 Answers

What is the difference between float and double?

0 Answers

For more MySQL Interview Questions Click Here