# this assumes the mysql software is installed in /usr/local/mysql #inc := /usr/local/mysql/include/mysql #lib := /usr/local/mysql/lib # if you have not installed the mysql software yet, try this instead topdir := /home/mysql/mysql-5.5.35
# this assumes the mysql software is installed in /usr/local/mysql
#inc      := /usr/local/mysql/include/mysql
#lib      := /usr/local/mysql/lib
# if you have not installed the mysql software yet, try this instead
topdir   := /home/mysql/mysql-5.5.35
inc      := $(topdir)/include
lib      := $(topdir)/libmysqld
cxx      := g++
cppflags := -i$(inc) -d_thread_safe -d_reentrant
cxxflags := -g -wall
ldflags  :=
# you can change -lmysqld to -lmysqlclient to use the
# client/server library
ldlibs    = -l$(lib) -lmysqld -lm -lcrypt -ldl -lz -lrt
ifneq (,$(shell grep freebsd /copyright 2>/dev/null))
# freebsd
ldflags += -pthread
else
# assume linux
ldlibs += -pthread
endif
# this works for simple one-file test programs
sources := $(wildcard *.cc)
objects := $(patsubst %cc,%o,$(sources))
targets := $(basename $(sources))
all: $(targets)
clean:
    rm -f $(targets) $(objects) *.core
---
#include
#include
#include
using namespace std;
const char *server_options[] =
       { mysql_test, --defaults-file=my.cnf, null };
int num_elements = (sizeof(server_options) / sizeof(char *)) - 1;
const char *server_groups[]= { libmysqld_server,
                               libmysqld_client,
                               null};
bool is_server_started= false;
mysql *mysql= null;
const char *db= null;
void start_server()
{
  cout
  if (mysql_library_init(num_elements, (char **) server_options, (char **) server_groups)) {
    is_server_started= false;
    cout
  }
  else {
    is_server_started= true;
    cout
  }
}
void stop_server()
{
  cout
  mysql_server_end();
}
bool connect_server()
{
  cout
  bool rc = true;
mysql = mysql_init(null);
  if (!mysql)
    return rc;
if (mysql_real_connect(mysql, null, null, null, db, 0, null, 0))
    rc = false;
mysql->reconnect= 1;
  return rc;
}
void output_rows(mysql_res *res)
{
  mysql_row row;
  unsigned long n = 0;
while ((row= mysql_fetch_row(res)) != 0)
  {
    mysql_field_seek(res, 0);
    for (unsigned int i= 0 ; i
      cout
  }
}
bool get_dbs()
{
  mysql_res *res;
if (!is_server_started)
    return true;
if (!(res= mysql_list_dbs(mysql, %)))
    return true;
output_rows(res);
  mysql_free_result(res);
  return false;
}
int main(int argc, char *argv[])
{
  start_server();
  if (is_server_started) {
    cout
    if (!connect_server()) {
      get_dbs();
    }
    stop_server();
  }
return 0;
}
---
[libmysqld_client]
[libmysqld_server]
basedir=/home/mysql/
datadir=/home/mysql/data
tmpdir=/home/mysql/tmp
log-error=/home/mysql/alert.log
lc_messages_dir=/home/mysql/share
innodb_data_home_dir=/home/mysql/data
innodb_log_group_home_dir=/home/mysql/data
，