root@daoluan:~# apt-get install mysql-server

root@daoluan:~# mysql –u root –p

root@daoluan:~# mysql -u root -p 
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g. 
Your MySQL connection id is 66 
Server version: 5.1.63-0ubuntu0.10.04.1 (Ubuntu)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its 
affiliates. Other names may be trademarks of their respective 
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

mysql> SHOW DATABASE;

mysql> create database library;

mysql> use library;

mysql> create table members (member_id int(11) not null auto_increment,fname varchar(50) not null,lname varchar(50) not null,tel varchar(15),email varchar(50) not null,primary key (member_id);

。。。。

#include<mysql.h>

#include <stdio.h>
#include <mysql/mysql.h>

int main(int argc, char *argv[])
{
	/* declare structures and variables */
    MYSQL *conn_ptr;
	MYSQL_ROW  row;
    MYSQL_FIELD * fields; 
	MYSQL_RES * result;
    unsigned int i,num_fields;

	/* initialize MySQL structure  */
    conn_ptr = mysql_init(NULL);

	/* connect to database */
    conn_ptr = mysql_real_connect(conn_ptr, "localhost", "root", "123456",
            "library", 0, NULL, 0);

	/* execute query */		
    mysql_query(conn_ptr,"select * from members");

	/* get result set */
    result = mysql_store_result(conn_ptr);

	/* get the number of fields */
	num_fields = mysql_num_fields(result);

	/* print result set */
    while((row = mysql_fetch_row(result)) != NULL)
    {
        for(i=0; i<num_fields; i++)
        {
            printf("%s ",row[i]!=NULL?row[i]:"NULL");
        }// for
        printf("\n");
    }// while

	/* clean up */
	mysql_free_result(result);
    mysql_close(conn_ptr);
    return EXIT_SUCCESS;
}

root@daoluan:/code/sample_mysql# gcc -o sample sample.c -lmysqlclient

root@daoluan:/code/sample_mysql# ./sample
1 John Doe 1234567 jdoe@somewhere.com
2 aaa aaa 1234567 aaa@aaa.com
3 bbb bbb 1234567 bbb@bbb.com
root@daoluan:/code/sample_mysql#