write a c++ program to add a user to mysql.the user should be
permitted to only "insert" into the given database
Answers were Sorted based on User's Feedback
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 |
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 |
What are the benefits of mysql?
What are the differences between binary and varbinary?
How to write optimized query in mysql?
How do I copy a table in mysql workbench?
What is deterministic in mysql?
How to create table show example
List the different types of normalization?
how to take mysql database backup?
What is procedural api?
How to change a password for an existing user via mysqladmin?
What are string data types?
How do I declare a variable in mysql?