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 determine the location of the data directory?
How can you plan the logshipping before processing?
Explain timestamp?
How can I create a database in mysql?
What are the technical specifications of mysql?
How do we use % when performing a search query?
How are mysql timestamps seen to a user?
What is the use of procedure in mysql?
How you will show all data from a table.
Is mysql relational?
How to use regular expression in pattern match conditions?
What is sql vs mysql?
What is mysql sleep process?
What is normalization and list the different types of normalization?
Why should I use mysql?