Interested to Buy Any Domain ? << Click Here >> for more details...
write a c++ program to add a user to mysql.the user should be
permitted to only "insert" into the given database
- 3 Answers
- 7003 Views
- Infosys, Webyog, I also Faced
- E-Mail Answers
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
What is the difference between truncate and delete in mysql?
Do while loop in mysql procedure?
What are the disadvantages of mysql?
How to create trigger in mysql workbench?
How MySQL Optimizes DISTINCT?
How can you count the total number of records of any table?
How to convert numeric values to character strings?
Write a query to fetch common records between two tables using mysql?
What are the 5 r's of managing behaviors?
suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?
What is user in mysql?
What are the benefits of mysql?
How show all tables in mysql query?
How to run 'mysql' commands from a batch file?
What are the steps required to view your mysql database?
