vishnu raju

• Mar 13th, 2012

 

Try this :)

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


""%s",name);


 


//retrieve Password from STDIN


"Enter the Password


""%s",password);


 


//retrieve database name from STDIN


"Enter the Database Name


""%s",database);


 


//creating SQL query in the form String


"create user ""@localhost identified by """);


//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


"grant SELECT on "".* to ""@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


");


 


}

sumanth.boss

 Profile Answers by sumanth.boss 

• May 26th, 2012

 

Dude, i tried to execute it . it execute successfully . but the grantACC is not getting executed . after adding user and trying to login him , it is saying error 1045(28000)