Guest User

Untitled

a guest
Apr 16th, 2018
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.76 KB | None | 0 0
  1. init_db(MYSQL **conn)
  2. {
  3. MYSQL_RES *res;
  4. MYSQL_ROW row;
  5.  
  6. char *server = "127.0.0.1";
  7. char *user = "root";
  8. char *password = "pass"; /* set me first */
  9. char *database = "benchmark";
  10.  
  11. *conn = mysql_init(NULL);
  12.  
  13. /* Connect to database */
  14. if (!mysql_real_connect(*conn, server,
  15. user, password, database, 0, NULL, 0))
  16. {
  17. fprintf(stderr, "%s\n", mysql_error(*conn));
  18. exit(1);
  19. }
  20.  
  21. /*
  22. if (mysql_query(*conn, "show tables"))
  23. {
  24. fprintf(stderr, "%s\n", mysql_error(*conn));
  25. exit(1);
  26. }
  27.  
  28. res = mysql_use_result(*conn);
  29.  
  30. printf("MySQL Tables in mysql database:\n");
  31. while ((row = mysql_fetch_row(res)) != NULL)
  32. printf("%s \n", row[0]);
  33.  
  34. mysql_free_result(res);
  35. */
  36. }
Add Comment
Please, Sign In to add comment