static void qServerEnd() { #ifndef Q_NO_MYSQL_EMBEDDED # if MYSQL_VERSION_ID >= 40000 mysql_server_end(); # endif // MYSQL_VERSION_ID #endif // Q_NO_MYSQL_EMBEDDED }
int db__driver_close_database(void) { mysql_close(connection); /* this will also release connection */ mysql_server_end(); return DB_OK; }
static PyObject* wsql_server_end(PyObject *self) { if (wsql_server_init_done) { #if MYSQL_VERSION_ID >= 40000 mysql_server_end(); #endif wsql_server_init_done = 0; Py_RETURN_NONE; } return wsql_raise_error(NULL); }
extern int mysql_db_cleanup() { debug3("starting mysql cleaning up"); #ifdef mysql_library_end mysql_library_end(); #else mysql_server_end(); #endif debug3("finished mysql cleaning up"); return SLURM_SUCCESS; }
static PyObject *_mysql_server_end( PyObject *self, PyObject *unused) { if (_mysql_server_init_done) { #if MYSQL_VERSION_ID >= 40000 mysql_server_end(); #endif _mysql_server_init_done = 0; Py_INCREF(Py_None); return Py_None; } return _mysql_Exception(NULL); }
/* button which handle the init of mysql server or quit the app */ void __fastcall TForm1::ToggleButtonClick(TObject *Sender) { if (!is_server_started) { mysql_server_init(NULL, NULL, (char **)server_groups) ; connect_server(); get_dbs(); } else { mysql_server_end(); Close(); } }
int main(int argc, char **argv) { mysql_library_init(0,0,NULL); if (argc > 1) get_options(argc, argv); get_envvars(); run_tests(my_tests); mysql_server_end(); return(exit_status()); }
int main(void) { MYSQL *mysql; MYSQL *mysqlr; MYSQL_RES *results; MYSQL_ROW record; mysql = mysql_init(NULL); unsigned int num = 0; int i = 0; MYSQL_FIELD *field; char sql[100] = "select * from fixtable limit 10"; mysqlr = mysql_real_connect(mysql, "127.0.0.1","root","1", "test", 3306,NULL,0); if(mysqlr == NULL) { printf("error\r\n"); printf("mysql_real_connect failed: %s\r\n", mysql_error(mysql)); exit(1); } while(1) { mysql_query(mysql, sql); results = mysql_store_result(mysql); num = mysql_num_fields(results); for(i=0;i<num;i++) { field = mysql_fetch_field_direct(results, i); printf("%10s|", field->name); } printf("\r\n"); while((record = mysql_fetch_row(results))) { for(i=0;i<num;i++) { printf("%10s|", record[i]); } printf("\r\n---------------------------------------------------------------------\r\n"); } printf("SQL: %s \r\n", sql); printf("\r\nsql>"); fgets(sql, 100, stdin); } mysql_free_result(results); mysql_close(mysql); mysql_server_end(); return 0; }
int main(void) { // int msi = mysql_server_init(num_elements, server_options, server_groups); // printf("mysql_server_init: %d \r\n", msi); mysql = mysql_init(NULL); // mysql_options(mysql, MYSQL_READ_DEFAULT_GROUP, "libmysqld_client"); // mysql_options(mysql, MYSQL_OPT_USE_EMBEDDED_CONNECTION, NULL); unsigned int num = 0; int i = 0; MYSQL_FIELD *field; mysqlr = mysql_real_connect(mysql, "127.0.0.1","root","111111", "stone", 3306,NULL,0); if(mysqlr == NULL) { printf("error\r\n"); printf("mysql_real_connect failed: %s\r\n", mysql_error(mysql)); exit(1); } mysql_query(mysql, "select * from fixtable limit 10"); results = mysql_store_result(mysql); num = mysql_num_fields(results); for(i=0;i<num;i++) { field = mysql_fetch_field_direct(results, i); printf("%s |", field->name); } printf("\r\n"); while((record = mysql_fetch_row(results))) { for(i=0;i<num;i++) { printf("%s |", record[i]); } printf("\r\n----------------------\r\n"); } mysql_free_result(results); mysql_close(mysql); mysql_server_end(); return 0; }
MySQLTemplate() { int rc = 0; MYSQL *db_connection; MYSQL_RES *query_result; MYSQL_ROW result_row; char *server = "localhost"; char *user = "******"; char *password = "******"; char *database = "LRDB"; int port = 3306; // default MySQL port //static char *server_options[] = { "mysql_test", "--defaults-file=my.cnf" }; //int num_elements = sizeof(server_options)/ sizeof(char *); lr_whoami(&vuser_id, &vuser_group, &scid); lr_message( "Group: %s, vuser id: %d, scenario id %d", vuser_group, vuser_id, scid); if (vuser_id == -1) { vuser_id = 1; } rc = lr_load_dll("C:\\Program Files\\MySQL\\MySQL Server 5.0\\lib\\opt\\libmysql.dll"); // You should be able to find the MySQL DLL somewhere in your MySQL install directory. if (rc != 0) { lr_error_message("Could not load libmysql.dll"); lr_abort(); } // Allocate and initialise a new MySQL object db_connection = mysql_init(NULL); if (db_connection == NULL) { lr_error_message("Insufficient memory"); return -1; } // Connect to the database if (mysql_real_connect(db_connection, server, user, password, database, port, NULL, 0) == NULL) { lr_error_message("error on connect: %s\n", mysql_error(db_connection)); return -1; } if (mysql_query(db_connection, "SELECT * FROM LATLogin;")!= 0) { lr_error_message("error on query: %s\n", mysql_error(db_connection)); return -1; } if ((query_result = mysql_store_result(db_connection)) == NULL) { lr_error_message("error on store: %s\n", mysql_error(db_connection)); return -1; } while (result_row = mysql_fetch_row(query_result)) { lr_output_message("%s - %s", result_row[0]); } mysql_free_result(query_result); // Free the MySQL object created by mysql_init mysql_close(db_connection); mysql_server_end(); return 0; }
int DBMS::end_server_sql(){ mysql_server_end(); return 0; }
//--------------------------------------------------------------------------- void __fastcall TForm1::FormDestroy(TObject *Sender) { if (is_server_started) mysql_server_end(); }
/* Class method: MySQL client library finalization */ void MysqlConnection_onstop(void) { if (mysql_get_client_version() >= 50003) mysql_library_end(); else mysql_server_end(); }