使用C语言在命令行中操作MySQL数据库的方法与技巧

Ubuntu自带mysql 所以不用安装。

登陆命令&＃xff1a;

mysql -uroot –p

然后根据提示输入密码

FAQ&＃xff1a;

1.      ERROR 1045 (28000): Accessdenied for user &＃39;nsfocus&＃39;&＃64;&＃39;localhost&＃39;

解决办法&＃xff1a;

# sudo /etc/init.d/mysqlstop

# sudo mysqld_safe --user&＃61;mysql --skip-grant-tables --skip-networking &

# mysql -u root mysql

mysql> UPDATE user SET Password&＃61;PASSWORD(&＃39;newpassword&＃39;) where USER&＃61;&＃39;root&＃39;;

mysql> FLUSH PRIVILEGES;

mysql> quit

#/etc/init.d/mysqld restart

# mysql -uroot -p

Enter password:输入上面更改的新密码如上是newpassword

mysql>

搞定&＃xff01;

Mysql命令大全

MySQL的C语言API接口

http://see.xidian.edu.cn/cpp/html/775.html

#include

#include

#include

#include

//定义数据库操作的宏&＃xff0c;也可以不定义留着后面直接写进代码

#define SELECT_QUERY "select * from result"

#define INSERT_QUERY "insert into result values(null, \"%s\", \"%s\", %d)"

int main(int argc, char **argv) //char **argv 相当于 char *argv[]

{

MYSQL mysql,*sock; //定义数据库连接的句柄&＃xff0c;它被用于几乎所有的MySQL函数

MYSQL_RES *res; //查询结果集&＃xff0c;结构类型

MYSQL_FIELD *fd ; //包含字段信息的结构

MYSQL_ROW row ; //存放一行查询结果的字符串数组

char qbuf[160]; //存放查询sql语句字符串

int num_row &＃61; 0;

int num_col &＃61; 0;

int i &＃61; 0;

//初始化

mysql_init(&mysql);

// 连接数据库

if (!(sock &＃61; mysql_real_connect(&mysql,"localhost","root","root","sping",0,NULL,0)))

{

fprintf(stderr,"Couldn&＃39;t connect to engine!\n%s\n\n",mysql_error(&mysql));

perror("");

exit(1);

}

/*

//插入

sprintf(qbuf,INSERT_QUERY, "123,234,23,12", "www.163.com", 0);

printf("%s\n", "insert into result values(null, \"123.123.23.23\", \"www.16.com\", 0)");

if(mysql_query(sock, qbuf))

{

fprintf(stderr,"Query failed (%s)\n",mysql_error(sock));

exit(1);

}

*/

memset(qbuf, 0, sizeof(qbuf));

sprintf(qbuf,SELECT_QUERY);

//查询

if(mysql_query(sock,qbuf))

{

fprintf(stderr,"Query failed (%s)\n",mysql_error(sock));

exit(1);

}

if (!(res&＃61;mysql_store_result(sock)))

{

fprintf(stderr,"Couldn&＃39;t get result from %s\n", mysql_error(sock));

exit(1);

}

num_row &＃61; mysql_num_rows(res); /* Get the no. of row */

num_col &＃61; mysql_num_fields(res); /* Get the no. of column */

//得到结果长度

printf("number of fields returned: %d\n", num_row);

printf("num_col: %d\n", num_col);

//显示结果

while(row&＃61;mysql_fetch_row(res))//获取具体的数据

{

for(i&＃61;0;i

{

printf("%s\t",row[i]);

}

printf("\n");

}

mysql_free_result(res);

mysql_close(sock);

exit(0);

return 0;

}