Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C++ C
Sir,
 
send me the answer for this C/C++ program to add a user to MySQL. The user should be permitted to only "INSERT" into the given database.
Posted 26-Jul-11 22:56pm
satmoo412
Comments
Stephen Wiria at 27-Jul-11 10:26am
   
I believe that are 2 different things to achieve. One part is connecting/accesing MySQL, and the other one is doing DML (INSERT) and DDL (GRANT)
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

you need to have mysql library to connect mysql database http://www.mysql.com/downloads/mysql/[^]
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Use have to use GRANT Syntax[^] and use a syntax like
 
GRANT INSERT ON db2.invoice TO 'jeffrey'@'localhost'
 
This will allow user 'jeffrey' only to INSERT data in table 'invoice'
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 881
1 OriginalGriff 270
2 Volynsky Alex 205
3 CPallini 180
4 Richard Deeming 175
0 OriginalGriff 5,640
1 Sergey Alexandrovich Kryukov 4,693
2 CPallini 4,540
3 George Jonsson 3,132
4 Gihan Liyanage 2,445


Advertise | Privacy | Mobile
Web02 | 2.8.140916.1 | Last Updated 27 Jul 2011
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100