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 '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 |
Post New Answer View All Answers
Is mysql from oracle?
Write a query to display current date and time?
What is datatype in mysql?
Can we join 3 tables in mysql?
What is difference between Sql server and MySql database? It may be silly question but i really dont know.
What does do in mysql?
What is the storage engine for mysql?
What is the difference between mysql_fetch_assoc and mysql_fetch_array?
Why do we use group by and order by function in mysql?
What is 'mysqlimport'?
What is a mysql view?
What is the innodb in mysql?
How to calculate the difference between two dates?
What tools available for managing mysql server?
How do I declare a variable in mysql?