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 '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
What is normalization and list the different types of normalization?
What is mysql server used for?
What is the maximum size of mysql database?
What are the differences between char and nchar?
What is blob and text in mysql?
What are the advantages/disadvantages of mysql and php?
How can you find out the version of the installed mysql?
How will show all records containing the name "sonia" and the phone number '9876543210'
How big is a blob mysql?
In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?
What data structure does mysql use?
How do I find mysql database?
what is mysql optimization in brief?
How do I completely remove mysql from windows?
What is regexp?