ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
   
 
Categories  >>  Software  >>  Databases  >>  MySQL
 
 


  

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
write a c++ program to add a user to mysql.the user should be 
permitted to only "insert" into the given database
 Question Submitted By :: Shashwat044
I also faced this Question!!     Rank Answer Posted By  
 
  Re: write a c++ program to add a user to mysql.the user should be permitted to only "insert" into the given database
Answer
# 1		 pls reply asap 
Is This Answer Correct ?    2 Yes 1 No
Shashwat044
 
  Re: write a c++ program to add a user to mysql.the user should be permitted to only "insert" into the given database
Answer
# 2		 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
Riyas_isno
 
 
 
  Re: write a c++ program to add a user to mysql.the user should be permitted to only "insert" into the given database
Answer
# 3		 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 ?    1 Yes 0 No
Riyas_isno
 

 
 
 
Other MySQL Interview Questions
 
  Question Asked @ Answers
 
How many ways we can we find the current date using MySQL?  3
please give me the answer for this: query which generates the second highest integer in the table?  8
how to display only 4 records from a table based on a condition for ex i have a table called products in that nid,prodname are fields i want to display only any 4 records of perticular product plz tell me  6
What is the difference between mysql_fetch_array and mysql_fetch_object? CTS4
What is the difference between primary and unique key CSC5
Print 3 highest salary  9
I have two sql database at different PC.how can link b/w database and database tables.  2
what is the difference between MyISAM and INNO DB in MySQL with the Advantage and disadvantage ABC3
What is the diff. bwt. primary key and unique key?  3
What?s the difference between PRIMARY KEY and UNIQUE in MyISAM? CSS4
What are the other commands to know the structure of table using MySQL commands except explain command? SigmaTree2
what is collation? how many types of installations in sql server?  3
 
For more MySQL Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2012  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com