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 'riyaz'@'localhost' IDENTIFIED BY 'riyaz';
GRANT insert ON db1.* TO 'riyaz'@'localhost';
END

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.

685


how we will Show selected records sorted in an ascending (asc) or descending (desc).

746


How do you restart mysql?

659


How do I update a variable in mysql?

674


What is user in mysql?

605


How can I see all mysql databases?

638


How do I run a query in mysql?

695


Can mysql and mariadb coexist?

749


Can we join 3 tables in mysql?

684


How do I stop a query in mysql workbench?

663


How do I kill a mysql connection?

670


How do I create a mysql username and password?

677


Which software is used for mysql?

688


what is cte? : Mysql dba

696


how to Return total number of rows.

732