http://blog.csdn.net/lilongherolilong/article/details/7516430

首先開啟遠程mysql訪問允許
mysql -u root -p?
mysql>use mysql;?
mysql>select 'host' from user where user='root';?
mysql>update user set host = '%' where user ='root';?
mysql>flush privileges;?
mysql>select 'host'?? from user where user='root';

到mysql的官網下載 Connector/C (libmysql) A client library for C development.

把下載的文件解壓
tar xvzf mysql-connector-c-6.0.2-linux-glibc2.3-x86-32bit.tar.gz?

把解壓以后的include文件夾里的文件拷貝到/usr/include/mysql文件夾下
mkdir /usr/include/mysql
cp -rf include/* /usr/include/mysql

把解壓以后的lib文件夾里的文件放到/usr/lib文件夾下
cp lib/* /usr/lib/

編寫測試程序

[cpp]?view plaincopy

#include?<stdio.h>??

#include?<stdlib.h>??

#include?"mysql/mysql.h"????

??

int?main(void)??

{??

????const?char?*host?=?"59.71.72.133";??

????const?char?*user?=?"root";??

????const?char?*pass?=?"";??

????const?char?*db???=?"mysql";??

????/*?定義mysql變量?*/??

????MYSQL?mysql;??

????MYSQL_RES?*rs;??

????MYSQL_ROW?row;??

????mysql_init(&mysql);?/*?初始化?*/??

????/*?連接數據庫?*/??

????if?(!mysql_real_connect(&mysql,?host,?user,?pass,?db,?0,?NULL,?0))??

????{??

????????printf("數據庫連接失敗：?%s\n",?mysql_error(&mysql));??

????}?else?{??

????????printf("數據庫連接成功！\n");??

????}??

????char?*sql?=?"select?host,user?from?user?order?by?rand()";??

????if?(mysql_query(&mysql,?sql)!=0)??

????{?/*?查詢?*/??

????????printf(?"%s",?mysql_errno(&mysql),?mysql_error(&mysql));??

????}??

????rs?=?mysql_store_result(&mysql);?/*?獲取查詢結果?*/??

????while?((row?=?mysql_fetch_row(rs)))??

????{????/*?獲取每一行記錄?*/??

????????printf(?"%s---%s",?row[0],?row[1]);??

????}??

????mysql_free_result(rs);?/*?釋放結果集?*/??

????mysql_close(&mysql);?/*?關閉連接?*/??

????return?1;??

}??

用以下命令使用 GCC 編譯 這個 C源文件.
gcc -o mysqltest -g mysqltest.c -lmysqlclient

./mysqltest

總結

以上是生活随笔為你收集整理的linux通过c语言编程访问远程mysql的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。