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 'riyaz'@'localhost' IDENTIFIED BY 'riyaz';
GRANT insert ON db1.* TO 'riyaz'@'localhost';
END
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to write date and time literals?
how to Return total number of rows.
How many queries can mysql handle?
Which is faster mysql or mongodb?
What is MySQL?
What is mysql common?
What is the default port for mysql and how it can change?
What is meant by sharding?
What does do in mysql?
Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?
What is a trigger in mysql?
How to enable or disable a row of a table using MySQL in struts?
How to update a root password.
How to create a table index in mysql?
How to validate email addresses in mysql?