yuvraj

• Dec 9th, 2011

 

This is program to add the add the user in database with privilege to SELECT only

Code
#include <mysql.h>


#include <stdio.h>


#include <string.h>


#include <stdlib.h>


int main()


{


 


char name[10];


char password[10];


char database[10];


char addUser[60]="";


char grantACC[60]="";


 


// initialize the variables within


MYSQL *connection=mysql_init(NULL);             //MYSQL is structure represents a handle to one database connection


 


 


// connect to the database


    if (!mysql_real_connect(connection,"localhost","root","mysql","clanguage", 0, NULL, 0)) {


            printf("in the if block");


            printf("Conection error : %s


", mysql_error(connection));            //For print error if connection is not stablished


            exit(1);


    }


 


 printf("connection established successfully


");


 


//retrieve User name from STDIN


        printf("Enter the User Name


");


        scanf("%s",name);


 


//retrieve Password from STDIN


        printf("Enter the Password


");


        scanf("%s",password);


 


//retrieve database name from STDIN


        printf("Enter the Database Name


");


        scanf("%s",database);


 


//creating SQL query in the form String 


        strcat(addUser,"create user ");


        strcat(addUser,name);


        strcat(addUser,"@localhost identified by ");


        strcat(addUser,password);


        strcat(addUser,"");


//execute the SQL query {create user <user name>@localhost identified by <password>}


        mysql_query(connection,addUser);


//puts(addUser);


 


 


//creating another SQL query in the String 


        strcat(grantACC,"grant SELECT on ");


        strcat(grantACC,database);


        strcat(grantACC,".* to ");


        strcat(grantACC,name);


        strcat(grantACC,"@localhost");


//execute the SQL query { grant SELECT on <database name>.* to <user name>@localhost }


        mysql_query(connection,grantACC);


//puts(grantACC);


 


 


//closing the connection


        mysql_close(connection);


 


        printf("User has been created Successfully


");


 


}