每种语言都有连接mysql数据库的方法，以下用Linux C语言为例，连接并查询数据库数据

#include
    
     #include
     
      main() {MYSQL      *conn;MYSQL_RES  *res;MYSQL_ROW  row;char *server = "localhost";char *user = "root";char *password = "nopasswd"; /* set me first */char *database = "mysql";char *query = "select Host,User,Password from user";int t, r;conn = mysql_init(NULL);if(!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0)){printf("Error connecting to database: %s\n", mysql_error(conn));}else{printf("Connected....\n");}t = mysql_query(conn, query);if(t){printf("Error making query: %s\n", mysql_error(conn));}else{printf("Query made...\n");res = mysql_use_result(conn);if(res){for(r=0; r<=mysql_field_count(conn); r++){row = mysql_fetch_row(res);if(row<0) break;for(t=0; t
     
    

编译连接数据库的文件

gcc con_mysql.c -L /usr/lib/mysql/ -lmysqlclient -o con_mysql

可以看出成功连接mysql库，并从user表中查处，Host、User、Password三个字段的数据。