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>


"""";


 


// initialize the variables within//MYSQL is structure represents a handle to one database connection


 


 


// connect to the database"localhost","root","mysql","clanguage""in the if block""Conection error : %s


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


");


 


//retrieve User name from STDIN"Enter the User Name


");


        scanf("%s",name);


 


//retrieve Password from STDIN"Enter the Password


");


        scanf("%s",password);


 


//retrieve database name from STDIN"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"User has been created Successfully


");


 


}