User Tools

Site Tools


c:mysql:mysql.h:mysql_change_user
click
to support this page (eg 0,42 € or so) Thanks.

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

c:mysql:mysql.h:mysql_change_user [2013/02/25 23:28]
Daniel Gohlke
c:mysql:mysql.h:mysql_change_user [2013/02/26 23:03] (current)
158.181.88.241
Line 5: Line 5:
  
 ==== description of mysql_change_user ==== ==== description of mysql_change_user ====
-mysql_change_user is in work by code-reference.com \\  +mysql_change_user is used to change the current user for the actual connection\\
-if you are faster... don't hasitate and add it+
  
 <code c> <code c>
-no example at the moment+#include <stdio.h> /* including standard library */  
 +#include <mysql/mysql.h> 
 +  
 +MYSQL *my; 
 +MYSQL_ROW  row; 
 +MYSQL_RES  *mysql_res;  
 + 
 +int main( void ){ 
 +char host[20]; 
 +char user[20]; 
 +char pass[20]; 
 +  
 +my = mysql_init(NULL); 
 +  
 +  
 +sprintf(host,"localhost"); 
 +sprintf(user,"username"); 
 +sprintf(pass,"password"); 
 +  
 +if (my == NULL ) { 
 +printf("Cant initalisize MySQL\n"); 
 +return 1; 
 +
 +  
 +if( mysql_real_connect (my,host,user,pass,NULL,0,NULL,0)  == NULL) { 
 +  printf("Error cant login\n"); 
 +  } else { 
 +  printf("Login correct\n"); 
 +  } 
 + 
 + mysql_select_db(my,"test"); 
 + 
 + 
 +if (mysql_change_user(my, "root", "somepass", "other_database")) 
 +
 +   fprintf(stderr, "Failed to change user.  Error: %s\n", 
 +           mysql_error(my)); 
 +} else { 
 +   printf("change user successfully\n"); 
 +
 + 
 +mysql_close(my); 
 +return 0; 
 +}
 </code> </code>
  
 ===== output of mysql_change_user c example ===== ===== output of mysql_change_user c example =====
-    no example at the moment+    Login correct 
 +    change user successfully
  
advertising
c/mysql/mysql.h/mysql_change_user.txt · Last modified: 2013/02/26 23:03 by 158.181.88.241

Impressum