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 is mysql_connect?
How to extract a unit value from a date and time?
Does facebook still use mysql?
How do I get a list of table names in mysql?
How big is a blob mysql?
How to filter data from a mysql database table with php?
How do I change the max connection in mysql?
What is the command used to create a database using php and mysql?
What is mysql gpl?
What is bigint in mysql?
Write a query to stop mysql in unix
I want to start and stop mysql on windows? How do I do that?