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 |
Is mysql free download?
What is the datatype for password in mysql?
What is mysql common?
Is mysql free for commercial use?
Is mysql port 3306 tcp or udp?
How many columns can be used for creating Index?
how many ways we can get the current date in mysql?
Can I use mysql for free?
What is a deterministic function?
How to increment dates by 1 in mysql?
how many table created when we create a table in mysql?
in a master-master replication with two masters and alternate slaves running on two systems.can i have a script or any mysql command to know which one is right now acting as master.