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
how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.
how we will Show selected records sorted in an ascending (asc) or descending (desc).
How do you restart mysql?
How do I update a variable in mysql?
What is user in mysql?
How can I see all mysql databases?
How do I run a query in mysql?
Can mysql and mariadb coexist?
Can we join 3 tables in mysql?
How do I stop a query in mysql workbench?
How do I kill a mysql connection?
How do I create a mysql username and password?
Which software is used for mysql?
what is cte? : Mysql dba
how to Return total number of rows.